Conditional formatting

[Arjay]

Hi

Does anyone know how to apply more than 3 conditional
formats to a single cell?

At the moment I am only able to apply up to 3 conditional
formats using the "Conditional Formatting" function; I
need to apply formatting so that the cell is shaded 1 of 5
different colours based on the value of the field.

Thanks

Raj

 

[David McRitchie]

Hi Raj,
If you include the default background, and use some formatting of
the Font with normal cell formatting you can expand a little bit, but
basically if you are going to exceed 3 you want to use an Event
macro. An Example can be found at
http://www.mvps.org/dmcritchie/excel/event.htm#case

Note comments, the installation of an event macro differs from other macros.