>I need some help with Conditional Formatting, please.
>
[quoted text clipped - 19 lines]
> helpful to have a bunch of red cells where the report has already been
> submitted.
Thanks for the help, Roger, but I couldn't get it to work. I am a novice at
Conditional Formatting and functions, so I probably got the syntax wrong.
Do you mean to add this string [=AND(G4="",TODAY()-F4>=0)] as one of the
Conditions (i.e. condition #3), or to add it to one of the existing
conditions?
I tried to use =(F4-TODAY())<=1 AND(G4="",TODAY()-F4>=0), but got a syntax
error.
> Hi Rod
>
[quoted text clipped - 24 lines]
> > helpful to have a bunch of red cells where the report has already been
> > submitted.
Roger Govier - 05 Feb 2007 20:17 GMT
Hi Rod
Your 1st Condition for Yellow format needs to be Formula IS
=AND(G4="",F4-TODAY()<4)
Your 2nd condition for the Red Format needs to be Formula Is
=AND(G4="",TODAY()-F4>=0)

Signature
Regards
Roger Govier
> Thanks for the help, Roger, but I couldn't get it to work. I am a
> novice at
[quoted text clipped - 43 lines]
>> > been
>> > submitted.
Rod from Corrections - 05 Feb 2007 21:39 GMT
Perfect! Thanks very much, Roger.
> Hi Rod
>
[quoted text clipped - 51 lines]
> >> > been
> >> > submitted.