• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Conditional formatting basics

EXCEL MUPPETT

New Member
yo clever ones. I am wanting to build a to do list but need help making the due date cell do the following


1) 1 week away from deadline change colour

2) On deadline change colour again

3) After deadline change colour again.


Anyone fancy helping...please


I am stoopid and have come here for therapy.
 

TessaES

New Member
You can use the following in the conditional formatting dialog:

1) between today()+1 and today()+7

2) equals today()

3) less then today()
 

oldchippy

Active Member
Hi,


Also take a look here this will help


http://chandoo.org/wp/2010/01/05/conditional-formatting-dates/
 
Top