thanks bob it worked perfectly, once again you have saved my ass.
--
Stuart


"Bob Phillips" wrote:

Assuming row 2, select column P and S

It can all be done in one formula as the formatting is the same


=OR(AND($P2<TODAY(),$S2=""),AND($P2<"",$S2<TODAY( )))
--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Stuart" wrote in message
...
ok more accident management stuff.

i do reports for our customers part of these reports are 2 fields.

Original Estimated Completion Date (Column P)
Revised Estimated Completion Date (Column S)

the jobs start on row 7 onwards.

basically i need 2 formulaes.

the first is based in Column P & will check to see if the value in P of
that
row is less than the value returned by "=TODAY()" if it does and the value
in
that rows S Column is blank then format with red background and white
text.

the second is based in Column S & will check to see if a value is in
Column
P if theres a value in Column P and the value in Column S is less than the
value returned by "=TODAY()" then format with red background and white
text.

this will remind the person completing the form to make sure that the
ECD's
are kept up to date, if theres a value in Column S that meets Column S's
red
background condition it will trigger the same formatting in Column P and
if
Column P goes red when Column S Gets Updated to be in the future of
present
day then both Columns P & S will return to normal formating.

i hope someone can understand exactly what i want it to do and provide the
necesarry formulae's. look forward to reading your replies to this.

--
Stuart