conditional formatting

[cloughie]

52	45	44
100	110	99
56	64	65

<tbody>
</tbody>

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