Multiple Conditonal Formats

D

Dave

I know how to use this in basics, say when the cell equals 1 change
colour to blue. How would you how ether change the colour again in the
same cell if the value was say 3, change it to green and so on?
 
D

David Biddulph

Set up your first condition and associated format, then hit the "Add" button
in the conditional formatting dialogue box.
 
D

Dallman Ross

Dave said:
Is there anyway you can get more than 3 colours to be displayed
in the cell?
Click to expand...

Aside from the add-in UDF another poster mentioned, you can actually
have four colors using conditional: you set up the default color
judiciously, and that counts as four (or one). Also, you can
use custom cell formatting (not conditional formatting) to give
certain numbers certain colors -- similar to how Excel already
offers to display negative numbers red as one optional number
format.

-dman-
 
Top