Change colour of cells if date exeeds 10 working/week days

**Onesock** · 05-19-2013, 04:09 PM

Hi Everyone

Please could someone help me with changing the cell colors of A:1 through A:14 , if the date in A:1 has exceeded todays date by 10 week/working days.

Thanks in advance

Onesock

**popipipo** · 05-19-2013, 04:29 PM

Please Login or Register  to view this content.

Try this one

**Onesock** · 05-19-2013, 04:39 PM

Hi Popipipo
Thanks for the reply.
Is this supposed to be a conditional formula ?
If so it doesnt seem to work for me .

Please help

Regards

Onesock

**popipipo** · 05-19-2013, 04:44 PM

Look at this

**Onesock** · 05-19-2013, 04:49 PM

I did a similar exercise , but put the date in as 1 June 2013.
The cell colour didnt change.
What I needing is all the cells from A:1 - A:10 to change colour if A:1 is more than 10 wordays from today.

Hope this is clearer

Onesock

**popipipo** · 05-19-2013, 05:44 PM

Ok; Then try this one

**Onesock** · 05-20-2013, 08:52 AM

Hi Popipipo

This is not working . The cell colours do not change to red as you have formated in the CF.
Any other ideas.

Regards

Onesock

**popipipo** · 05-20-2013, 09:02 AM

post een xls file with how you want it with manual coloring

**Onesock** · 05-20-2013, 09:32 AM

please find attached
Colour.xls

**popipipo** · 05-20-2013, 09:55 AM

A new attempt

**Onesock** · 05-20-2013, 10:48 AM

Hi Popipipo

No that does not work. The colour does not change . Have you tried it ?

**popipipo** · 05-20-2013, 12:34 PM

if I change A1 to 1-6-2013 the color disapear

**Onesock** · 05-20-2013, 04:54 PM

Nope - just not working.
If I type a date into A:1 and todays date is more than 10 work days from that date , A:1 - A:14 should turn red.

**popipipo** · 05-20-2013, 05:04 PM

I am sorry then I can't help you any further
I realy don't know why it is not working with you

**Onesock** · 05-20-2013, 05:08 PM

Ok thanks.

Anybody else have any ideas PLEASE ???

**Teethless mama** · 05-20-2013, 07:57 PM

NETWORKDAYS function is required Analysis ToolPak add-in for older versions prior to XL-2007

**daddylonglegs** · 05-21-2013, 06:35 AM

.....and Analyisis ToolPak functions like WORKDAY can't be used in conditional formatting in Excel 2003, even if ATP is enabled

10 working days is equivalent to 14 calendar days in most cases, is it sufficient to use this formula?

=A$1-TODAY()>14

or if you have to use workdays try using this formula somewhere on the worksheet, e.g. in cell Z1

=WORKDAY(A1,10)

and then in conditional formatting use

=A$1>Z$1

Change colour of cells if date exeeds 10 working/week days

LinkBack

Thread Tools

Rate This Thread

Display

Change colour of cells if date exeeds 10 working/week days

Re: Change colour of cells if date exeeds 10 working/week days

Re: Change colour of cells if date exeeds 10 working/week days

Re: Change colour of cells if date exeeds 10 working/week days

Re: Change colour of cells if date exeeds 10 working/week days

Re: Change colour of cells if date exeeds 10 working/week days

Re: Change colour of cells if date exeeds 10 working/week days

Re: Change colour of cells if date exeeds 10 working/week days

Re: Change colour of cells if date exeeds 10 working/week days

Re: Change colour of cells if date exeeds 10 working/week days

Re: Change colour of cells if date exeeds 10 working/week days

Re: Change colour of cells if date exeeds 10 working/week days

Re: Change colour of cells if date exeeds 10 working/week days

Re: Change colour of cells if date exeeds 10 working/week days

Re: Change colour of cells if date exeeds 10 working/week days

Re: Change colour of cells if date exeeds 10 working/week days

Re: Change colour of cells if date exeeds 10 working/week days

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions