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

  • Thread starter Thread starter walltur
  • Start date Start date
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.
 
Conditional Formatting

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

Condition2
Formula Is: =$A1="no"
format cell as Red
 
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.
 
You must log in or register to reply here.

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

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

Back
Top