If condition

L

Lavanya

I have set the user to select an entry from a list of three, but i want to
format the cell depending on what the user select from the list. for example,
i select 'yes' from a list of 'yes, no, dont know'. As soon as i select 'yes'
want the cell to be colored blue automatically. Is it possible to do? if so
how?
 
S

Stefi

Use !
Select cells (column) you want to format,
Choose Format/Conditional formatting
Condition 1: Cell value "yes", Choose blue color
Condition 2: Cell value "no", Choose ??? color
Condition 3: Cell value "don't know", Choose ??? color

Regards,
Stefi

„Lavanya†ezt írta:
 
L

Lavanya

Hi Stefi,

Thanks for your reply this was helpfull but i have another problem. earlier
i need to color the cells for three conditions; now i have five such
conditions. Eg: if the selection is:
good - blue
better - green
best - brown
bad - yellow
worst - red
Conditional Formatting allows me till three conditions. how do i make it for
five?

Lavanya.
 
S

Stefi

Unfortunately there is no way to increase No. of conditions in Conditional
formatting. In fact you can differentiate four cases (3 conditions + one
default case when none of the 3 conditions are met).
If you desperately need more cases then you have to write a Change event
macro!

Regards,
Stefi

„Lavanya†ezt írta:
 
Top