How can I change the color of the cell when someone enter any number or character?

  • Thread starter Thread starter Sajan.sajan
  • Start date Start date
S

Sajan.sajan

Hi,

I am trying to make a templet for my school project. The file has
number of questions with the answer YES and NO. If someone choose YES,
I want to change the cell background color to GREEN and if the answer
is NO, the color has to be RED.

Thank you,
Sajan
 
Select a cell where answer will be.
Format>Conditional Formatting
Set "Cell Value is" "equal to" and type "Yes" (without quotes) in the right
text box.
Select "Format" > "Patterns" tab and select green.
Click "Add"
Repeat above and typing "No" and selecting red.

Use Format Painter to distribute formatting to the other answer cells

HTH
Sandy
 

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 change the color of the cell when someone enter any number or character? 6
Excel VBA - counting cells by colors and names to it in two different rows. 0
Excel Change tab color in Excel with Conditional Formatting formula in a cell 0
Excel Macro to automatically go to the right of the last colored cell 0
Change Color of cell 3
Windows 7 Default page color for e-mail (Outlook) 1
how to change color gradients in a bar chart 0
Excel Can you lock the value of a cell but not the format? 1

Back
Top