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.

"Stefi" wrote:

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:

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?