Conditional formatting

  • Thread starter Thread starter Arjay
  • Start date Start date
A

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
 
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.
 
Back
Top