Row Formatting

[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

 

[Frank Kabel]

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

 

[mzehr]

In addition to Frank's reply check out David McRitchie's
great web site:
http://www.mvps.org/dmcritchie/excel/event.htm#rowcolor

One of the problems with conditional formatting like that
is that you are limited to 3 if conditions. David
provides a VBA workaround that you may find helpful.