Greater and less than

**derekfarr** · 03-04-2011, 05:58 AM

Hi, I am wanting to format Cell C to be coloured green when Cell A - Cell B lies between -2 and 2 , hope someone can help.TIA

**DonkeyOte** · 03-04-2011, 06:16 AM

Assuming we're talking about C1 ... with C1 the active cell apply a Conditional Format FormulaIs rule of:

=ABS($A1-$B1)<=2
format Green

**EEL1966** · 03-04-2011, 06:48 AM

You can also do this:

Activate the cell in question
Open format cell
Choose tab Number
Choose Category Custom
Put the text below in as Type

[Black][<=-2]-0.00;[Black][>=2]0.00;[Green]0.00

Now you can drag the formula and the format will follow.

**DonkeyOte** · 03-04-2011, 06:51 AM

That's true if

a) C actually contains =A-B (unspecified)

b) You wish to format the Font rather than Interior Fill

**EEL1966** · 03-04-2011, 07:32 AM

Right. But I have a question. I tried to copy exactly what you wrote in your first reply into cell c1 and got and error. Does it only work in 2010 (I use 2007) or what are I doing wrong.

**DonkeyOte** · 03-04-2011, 07:39 AM

The formula posted is not to be placed in C1 rather it is for a Conditional Format rule.
(if placed directly in C1 the formula would return either TRUE or FALSE - assuming both A1 & B1 are numbers/blank of course)