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?

e.g.
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 •


#1
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:

http://www.ozgrid.com/VBA/excel-con...

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

http://www.ozgrid.com/Excel/font-fo...

MIKE

http://www.skeptic.com/


Report •
Related Solutions


Ask Question