For the first part select f2 and

Format|conditional formatting|formiula is and paste in

=(F2-TODAY())<7

Use the format painter to apply it to the full range of cells.

For G7 paste in the conditional format

=(G7-F7)28

Is that OK?

Mike



"Stuart" wrote:

hi everyone

i work for an accident management company and have a few new reports that
need some complex conditional formating i will details the requirements below
hopefully someone can help.

No Estimate Report:
i have a date in column F data starts on row 2 if any date in column if is
equal to or more than 7 in the past to todays date "=TODAY()" then i want
that date in column F to be highlighted in red background with white text.
that will then allow me to prioritise which jobs from each bodyshop need to
be chased urgently and which ones can wait a day or so this report takes me
about 2 days to complete so its important i deal with the urgent ones first
hence the need for this formulae.

G4S Cash Report:
i have the accident date in F7 & the bookin Date in G7 if the difference
between these 2 dates is equal to or greater than 28 then i want the date in
g7 to have red background and white text this will indicate to me if it the
time between the accident and the vehicle coming into the bodyshop is greater
than 28 days if it is then i have to move that job to a seperate report so
its important i can identify if it has exceeded 28 days or not.

any help you guys can provide would be greatly appreciated.
--
Stuart