Conditional Formatting

[hibiscus11]

Please see below. How would I show -

if column B = 'SL1' then if column C > (column a - 2), display Red or display letter R, otherwise display green or G), if column B = 'SL2' then if column c>(column a-3), display Red or R, otherwise green or G), if column B = 'SL3' then if column c>(column a-4), display Red or R, otherwise green or G

SL1 is Column A-2 days but how would I show this as Column A-48 hrs?

I hope this makes sense and thanks in advance for your help.

(I can't seem to attach file so details below)

Date loaded SLA Date submitted
20/10/2007 SL1 22/10/2007
20/10/2007 SL2 21/10/2007
20/10/2007 SL3 26/10/2007

[Dav]

depending if you mean > or >= something like

=IF(C2>A2-1-RIGHT(B2,1)*1,"R","G")

Regards

Dav