I have a table with two columns on a worksheet. The first column holds a
value that changes according to an Increment Value. So while sometimes the
column might increment by 5, other times it might increment by 10. The
column entries sometimes reach values up to 100,000. I want to use
conditional formatting to change the fill color (background color) every 100.
So if the increment is 5, then the first 20 rows will be gray, and the next
20, white, and so on. If the increment is 10, then each 10 rows, the color
changes. My problem is the second column. The formula here depends on so
many different factors, that the numbers don't coincide with the first
column. How can I make the formatting on the cells in the second column
match the formating on the cells in the same row in the first column?
Conditional formatting only looks at the value of the cell it's changing and
not any other cell.