Hi all,

This is my first post so I will apologise if I don't explain myself very well!! :-)

On a spread sheet I am doing for work there are 3 relevant columns....

RC1 which is date sent
RC2 which is date due (which has the formula =IF(RC[-1]=0, "", RC[-1]+21) in it to make the date due 21 days after the date in RC1)
RC11 which is date received.

Now, I'm attempting to do a bit of conditional formatting so that when a date is added into RC11, if it is 7 days after the date in RC2, RC11 cell will turn red and if it is less than 7 days then it will turn green.

At the moment I have put in the formula for the cell's to turn red and it seems to work. The formula I have used is:

=RC11-RC2>=7 (format to red)

But when I try to do something similar for green (<7 days) it either turns all the cells in RC11 green or overrides the conditional formatting for the red.

I'm not really that good at things like this and now I am completely stuck!!!

I would appreciate any or all help that anyone could provide!!

Thank you and sorry if I haven't explained this very well :-s


:-)