Ask Your Question

gumbypie's profile - activity

2018-03-28 14:30:26 +0100 received badge  Notable Question (source)
2018-03-28 14:30:26 +0100 received badge  Famous Question (source)
2017-10-15 18:06:50 +0100 commented answer Format array cells for certain values

Many thanks. Can't upvote yet. This is what I was trying to do. Answer from @Vitaly got me up and running but I will

2017-10-15 18:04:27 +0100 commented answer Format array cells for certain values

Thanks. The reference column is too big though -- thousands of values.

2017-10-15 18:03:41 +0100 commented answer Format array cells for certain values

Thanks. Exactly what I was trying to do. And the grid of results provides some useful metrics -- an added bonus.

2017-10-15 18:02:58 +0100 commented answer Format array cells for certain values

Can't upvote yet. Many thanks.

2017-10-15 17:55:16 +0100 marked best answer Format array cells for certain values

I have a large rectangular array of numbers and a separate column of numbers. For each cell in the rectangular array whose value is also in the column, I would like to set a particular background colour. The rectangular array and the column can be on the same sheet or different sheets.

Seems it should be straightforward to use a macro to loop through the array and do a VLOOKUP on the column for each value. Just haven't been able to pull that off.

Thanks.

2017-10-15 17:55:16 +0100 received badge  Scholar (source)
2017-10-15 12:10:36 +0100 received badge  Popular Question (source)
2017-10-15 04:16:25 +0100 edited question Format array cells for certain values

Format array cells for certain values I have a large rectangular array of numbers and a separate column of numbers. For

2017-10-15 04:06:13 +0100 edited question Format array cells for certain values

Format array cells for certain values I have a large rectangular array of numbers and a separate column of numbers. For

2017-10-15 04:06:13 +0100 received badge  Editor (source)
2017-10-15 03:58:02 +0100 edited question Format array cells for certain values

Format array cells for certain values I have a large rectangular array of numbers and a separate column of numbers. For

2017-10-15 03:57:32 +0100 asked a question Format array cells for certain values

Format array cells for certain values I have a large rectangular array of numbers and a column of numbers. For each cel