conditional formating in excel 2003

[cds]

Hi I am using excel 2003, I have difficulty in using conditional formatting for more than 3 conditions. Is there any way to use more than 3 conditions and format with more than 3 colors.



Please guide me


thanks



cds

 

[Andrew Poulsom]

You can have 4 conditions if you format the cells that don't match the three conditional formatting conditions.

 

[cds]

hi, what to do when there are more than 4 to conditions to perform or display the result .

 

[Andrew Poulsom]

That would require VBA. A Google search will give you plenty of hits.