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

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.

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

Conditional Formatting

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

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


"walltur" wrote:

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.

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

Hi Waltur,

Select the cells that you want to change colour.

Then select FormatConditional Formatting.

Cell Value IsEqual 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.

"walltur" wrote:

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.