adding color to the results of IF statements

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to make an IF statement results have different colored cells
depending on their outcome. For instance, if A=B, I want the cell to say "GO"
with green fill around it. If A does not =B, I want the cell to say "STOP"
with red fill aound it. How can I do this?
 
In a seperate cell, enter your formulas ...

=IF(A1="B","GO","STOP")

Then select this cell, goto Format (menu) | Conditional Formatting | Formula
Is ...

=B1="GO"

Format condition to Green, confirm with the Ok button. Now set the regular
format of the cell to a background color of Red. Btw, this also assumes
that you entered this in cell B1; if not, change the B1 in the Conditional
Format formula to match that of the cell address you are inputing it on.
 
You need conditional formatting.

Look up 'Highlight cells that meet specific conditions' in the Answer
wizard in help


--

HTH

RP
(remove nothere from the email address if mailing direct)
 

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 to extract separated text by many commas in Excel? 0
Function for summing or counting cells based on a specified fill color 2
Excel Macro to automatically go to the right of the last colored cell 0
Format cell based on cell color 3
IF OR AND in same conditional formula 2
Counting Cells by Format 2
How to Color a Cell Based on a Range of Cells with Colors 1
how can I use conditional formatting with formula and 3 poss resul 1

Back
Top