Conditional Format - Array based on cell in column

T

Thanh

How do you apply a conditional format based on a cell in single column and
apply it across multiple columns?

Example:
A B C D
ROW1 Critical
ROW2 High
ROW3 Critical

Conditional Format - if text in column "A" = "Critical" format all text
color red in columns A - D. Thanks.
 
B

Bob I

I think you will need to use a macro to do that. Conditional only refers
to the cell contents.
 
Top