Changing Cell colors with conditions

[Bahadir]

Hi,

Is it possible to control the color of a cell?

I mean let's say I want to change the color of D1 and if A1 + B1 >
color is green or A1 + B1 < 0 color is red.

How can I do this?

Thank you all for any feedback.

Bah

 

[Gord Dibben]

Baha

Select D1

Format>Conditional Formatting

Formula is: =a1+b1>0 format green

Add another =a1+b1<0 format red

What would you like to see if a1+b1=0

You could add a third format.

Gord Dibben Excel MVP

 

[Frank Kabel]

Hi
in additions to Gord's answer you may have a look at
http://www.contextures.com/xlCondFormat01.html
http://www.cpearson.com/excel/cformatting.htm