HI Forum,
I am able to use conditional formatting to fill a cell with a certain color (green) if its value is greater than another cell, and fill it red if its value is less than that cell. But I am having a hard time copying these rules to other relative cells. For example if B1 is greater than A1, it fills green. If B1 is less than A1, it fills red.
What do I do so these same rules apply to B2/A2, B3/A3, etc?
Thanks in advance!
Bookmarks