Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formatting cells
How do set up a cell to change color if I put a yes or no in the cell? Red=
no yes = Green |
#2
|
|||
|
|||
Hi
use conditional formatting, click on the cell in question, choose format / conditional formatting choose cell value is choose equal to type yes click on the FORMAT button - in the middle of the font tab you can set text colour, use patterns to set background colour. click OK then click ADD choose cell value is choose equal to type no click on FORMAT button, set the formatting, click OK twice. hope this helps Cheers JulieD "mesh" wrote in message ... How do set up a cell to change color if I put a yes or no in the cell? Red= no yes = Green |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
To safety merge cells without data destroyed, and smart unmerge! | Excel Discussion (Misc queries) | |||
Print cells that meet conditional formatting criteria | Excel Discussion (Misc queries) | |||
background formatting across multiple cells | Excel Discussion (Misc queries) | |||
Cells losing formatting | Excel Discussion (Misc queries) |