software

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,
BrettBrett

Select A1 CTRL and select B3:B10 and Formatgt;CFgt;Formula 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, quot;brettquot; gt; wrote:

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

Perfect. Thanks.Thanks for the feedback.

Gord

On 20 Dec 2005 13:34:37 -0800, quot;brettquot; gt; wrote:

gt;Perfect. Thanks.