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

Change the colour of a neighbouring cell 6
Program buttons to create a word document 0
Cumulative formula for word table 0
Can't format 'invert if negative' colour programmitically (macroignores it!) 0
Using 3 coloured Cells to Format a 4th Cell 12
Word 2016 opening sooo slow 0
Changing Celll colour as a result of a calculation 3
"If" function and Upcoming Dates 1

Top