Condional formating
 

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?

Expanded a little futher
 

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

Expanded a little futher
 

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
"Chad" wrote:

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