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

How can i put text in a cell depending on colour 0
Excel does not accept text format! 0
cell vlue based on cell back colour 7
change colour of cell in word table following numerical input 1
Force input & colour cells 4
How to make repeating drop-down lists? 2
Using colour conditional formatting to show whether due date has past 0
Formula for Dates and CF Colour then convert to Text 3

Top