If condition
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?
|