Row Formatting

C

Chance

How can you have the text in every cell of a row change to
a certain color based on the value of the first cell in
the row?

Example; IF A1= Rentals then the whole row's text would be
in red and if A1 = Boats then it would be in Blue.

Thanks,
Chance
 
F

Frank Kabel

Hi
try the following:
- select row 1
- goto 'Format - Conditional Format'
- enter the following formula
=$A1="Rentals"
- choose your format
 
Top