how do I get cells to automaticly change colour on data input?

W

walltur

I am wanting cells to change colour to red if 'no' inputted and green if
'yes'. The no/yes are set up on validation drop down boxes.
 
T

Teethless mama

Conditional Formatting

Condition 1
Formula Is: =$A1="yes"
format cell as Green

Condition2
Formula Is: =$A1="no"
format cell as Red
 
G

Gav123

Hi Waltur,

Select the cells that you want to change colour.

Then select Format>Conditional Formatting.

Cell Value Is>Equal to> Type Yes in the empty box and click the format
button, choose your format. Click Add button and set your second condition.

Hope this helps,

Gav.
 
Top