Condional formating

  • Thread starter Thread starter Chad
  • Start date Start date
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?
 
I would like to highlight the above mention with 5 different colors based on
5 different possible values of column B.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with format painter and conditional format 2
Hlp! Reverse select in range 4
Conditional Format 9
condtional formatting in office 2007 is not working properly 1
Cell references in excel vba code 4
if function with different criteria 4
Referencing every nth cell in a new column 1
Multiple criteria question 1

Back
Top