ExcelBanter - Cell colour in relation to IF results

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Cell colour in relation to IF results (https://www.excelbanter.com/excel-discussion-misc-queries/261960-cell-colour-relation-if-results.html)

Rob

Cell colour in relation to IF results

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?
--
Thanks for your help

Rob

JLatham

Cell colour in relation to IF results

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.

"Rob" wrote:

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?
--
Thanks for your help

Rob

Eduardo

Cell colour in relation to IF results

Hi,
use conditional formating, where the formula is enter

=$C$10 choose color green

do the same again enter formula

=$C$1<0 choose color red

"Rob" wrote:

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?
--
Thanks for your help

Rob

All times are GMT +1. The time now is 11:40 AM.