Color Match Adjacent Cell
 

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

Doug

Color Match Adjacent Cell
 

apply the same condition
--
Gary''s Student - gsnu200769


"DOUG ECKERT" wrote:

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

Doug

Color Match Adjacent Cell
 

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

"Gary''s Student" wrote:

apply the same condition
--
Gary''s Student - gsnu200769


"DOUG ECKERT" wrote:

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

Doug

Color Match Adjacent Cell
 

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.
--
David Biddulph

"DOUG ECKERT" wrote in message
...
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

"Gary''s Student" wrote:

apply the same condition
--
Gary''s Student - gsnu200769


"DOUG ECKERT" wrote:

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

Doug