Conditionally formatting other cells?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

brett - 20 Dec 2005 18:33 GMT

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

Reply to this Message

Gord Dibben - 20 Dec 2005 20:40 GMT

Brett

Select A1 CTRL and select B3:B10 and Format>CF>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

>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

Reply to this Message

brett - 20 Dec 2005 21:34 GMT

Perfect. Thanks.

Reply to this Message

Gord Dibben - 20 Dec 2005 23:09 GMT

Thanks for the feedback.

Gord

>Perfect. Thanks.

Reply to this Message