G7 is the date the vehicle is due to come onsite, F7 is the date the accident
happened i need to determine the number of days between the 2 dates and if
that value is equal to ior greater than 28 then it has a red background with
white text.
--
Stuart


"Bob Phillips" wrote:

What do you have in F7 and G7?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Stuart" wrote in message
...
thanks bob the No Est formulae worked perfect but the G4S Cash Report
formulae didnt work at all could you please advise?
--
Stuart


"Bob Phillips" wrote:


"Stuart" wrote in message
...

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.

Select all the cells and use a formula of

=AND(F2<"",F2<=TODAY()-7)

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.

=ABS(F7-G7)=28