Prev: Converting Hours to Decimal
Next: Compare dates in two different ranges
From: Jenny P Jenny on 24 May 2010 12:09
I've looked at quite a few posts but can't seem to get this to work.

I have a spreadsheet with information about delivery dates and within forty
eight hours of the delivery date I have to provide information.

I need the row colour to change according to the date that is entered in
column J, if the current date is one day after the entered delivery date I
need the row to turn yellow. If the current day is two days after the
delivery date I need the row to turn orange and red if it's three days.
From: Don Guillett on 24 May 2010 12:39
formula is =j10+1>=today()

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett(a)gmail.com
"Jenny P" <Jenny P(a)discussions.microsoft.com> wrote in message
news:1EC26E2C-61B3-4D69-B4F9-AD9B741E46C4(a)microsoft.com...
> I've looked at quite a few posts but can't seem to get this to work.
>
> I have a spreadsheet with information about delivery dates and within
> forty
> eight hours of the delivery date I have to provide information.
>
> I need the row colour to change according to the date that is entered in
> column J, if the current date is one day after the entered delivery date I
> need the row to turn yellow. If the current day is two days after the
> delivery date I need the row to turn orange and red if it's three days.

 | 
Pages: 1
Prev: Converting Hours to Decimal
Next: Compare dates in two different ranges