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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

automatic colour change of cells. 3
Force input & colour cells 4
how to update certain text in a cell according to thecell colour 1
Data Validation - Cell Colour 3
Formula for Dates and CF Colour then convert to Text 3
Formatting cells 1
Change colour of cells depending on entry in one cell 9
How do I create a drop down cell menu with different colour cells 1

Top