Cell colour in relation to IF results

R

Rob

I want a cell to be coloured red if the result of a simple calculation is
negative, and coloured green if the result is positive. Can anyone tell me
how to do this?
 
J

JLatham

Use Conditional Formatting.
Cell Value "less than" 0 and set format to red (font or fill), then add
a second condition
Cell Value "greater than" 0 and set the format to green.
 
E

Eduardo

Hi,
use conditional formating, where the formula is enter

=$C$1>0 choose color green

do the same again enter formula

=$C$1<0 choose color red
 

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

Using 3 coloured Cells to Format a 4th Cell 7
Changing Celll colour as a result of a calculation 2
Conditional formatting in Excel 2010 2
Pass or Fail (green or red) criteria for cell? 6
Red cell for negative numbers in Excel 1
Can you regonise a coloured cell in a formula? 2
Cell formats 2
coloured roes static while sorting data 3

Top