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