conditional formatting

[cloughie]

[TABLE="width: 500"]
<tbody>[TR]
[TD]52[/TD]
[TD]45[/TD]
[TD]44
[/TD]
[/TR]
[TR]
[TD]100[/TD]
[TD]110[/TD]
[TD]99
[/TD]
[/TR]
[TR]
[TD]56[/TD]
[TD]64[/TD]
[TD]65[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Hi can anyone help me with the above?
I need to conditional format the third column so that if the cell is more than -5 of cell B then it highlights in red.
If column B is between -4 and -1 of column b then it should be amber.

 

[Fluff]

For amber
=AND(C1<B1-1,C1>B1-4)
For red
=C1>B1-5

Change the C1 & B1 to reflect the first row in the applies to range

 

[pgc01]

Hi

The html gobbled some characters in Fluff's first formula:

=AND(C1<b1-1,c1>B1-4)

 

[Fluff]

Thanks for that pgc01, I keep forgetting about the < & > characters