Cell Colour Formatting in Excel

Microsoft Excel 2003 (full product)
March 30, 2011 at 04:11:00
Specs: Windows XP
Hi, I want to have cells change colour when a certain value range is displayed. I know you can use Format>Conditional Formatting but this only has a maximum of 3 conditions. Please can someone tell me if it is possible to add more conditions in without using an IF formula?

cell = 1 then display in Blue
cell = 2 then display in Green
cell = 3 then display in Red
cell = 4 then display in Yellow etc

See More: Cell Colour Formatting in Excel

Report •

March 30, 2011 at 07:02:17
That's going to depend of what type of data your talking about.

The usual way is with VBA code, see here:


but there is a non-VBA method, see here:




Report •
Related Solutions

Ask Question