Color Match Adjacent Cell

D

DOUG ECKERT

I have a conditionally formatted cell which is green. How would I instruct
the cell below it to match the color?

Doug
 
D

DOUG ECKERT

Gary's Student: But, the adjacent cell is blank. I want the cell below the
formatted cell to show the same color, even though there is nothing in it.

DOUG
 
D

David Biddulph

Use Formula Is, rather than Cell Value Is, in your Conditional Formatting.
Specify an appropriate formula using the value in the previous cell, if
that's what you want to use to determine the colour of both cells. If you
use absolute addressing the same formula will do for both cells.
 
Top