Conditionally formatting other cells?
 

If cell A1 is 0, I'd like the text of A1 and B3 thru B10 to be gray. I
know how to conditional format for the current cell but how can I also
format other cells based on the current cell's condition?

Thanks,
Brett

Conditionally formatting other cells?
 

Brett

Select A1 CTRL and select B3:B10 and FormatCFFormula is

=$A$1=0

NOTE the $ signs to anchor A1 as the key cell.

Format as you wish and OK your way out.


Gord Dibben Excel MVP

On 20 Dec 2005 10:33:04 -0800, "brett" wrote:

If cell A1 is 0, I'd like the text of A1 and B3 thru B10 to be gray. I
know how to conditional format for the current cell but how can I also
format other cells based on the current cell's condition?

Thanks,
Brett

Conditionally formatting other cells?
 

Perfect. Thanks.

Conditionally formatting other cells?
 

Thanks for the feedback.

Gord

On 20 Dec 2005 13:34:37 -0800, "brett" wrote:

Perfect. Thanks.