Condional formating

C

Chad

I have data in the range A1:E20 and I want it to highlight the a row from A-E
if column B value=0.

How do I do this?
 
C

Chad

I would like to highlight the above mention with 5 different colors based on
5 different possible values of column B.
 
D

Dave Curtis

In Excel 2003, you're limited to 4 colurs, (3 conditional and a default)
unless you go down the VBA route.
In Excel 2007, you can have as many conditional formats as you want.

Dave
 
Top