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?

use conditional formatting
--
Gary''s Student


"Lavanya" wrote:

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?

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?

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?

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:

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?