colour cell based on date

**Back2Basics** · 02-11-2009, 10:49 AM

It's quite funny that i'm asking this cause I answered a similar quesstion earlier. But I can't seem to get my head around the thinking of this one.

I am trying to create a formatting so that if todays date is greater than the date in the cell the cell is coloured red. And if todays date is > today()-14 <today() the cell is coloured yellow.

I don't think it is as simple as using conditionaly formatting, it may well be but like I said I can't quite get my head around what I need to do.

**NBVC** · 02-11-2009, 11:00 AM

And if todays date is > today()-14 <today()

this doesn't make sense...

**Back2Basics** · 02-11-2009, 11:02 AM

Sorry should be:

if todays date > date in cell -------------------> Red

if date in cell >today-14 & <today -------------> Yellow

**NBVC** · 02-11-2009, 11:05 AM

You mean... see attached...

**Back2Basics** · 02-11-2009, 11:12 AM

Yeah that is right, I just found myself writing a little message trying to explain how it wasn't quite what i was looking for.

I feel so silly, like I said just could get my head round it - i was thinking about it backwards. Just one of those moments, you know what you can't see the wood for the trees and that.

Thanks again NVBC

**Back2Basics** · 02-11-2009, 11:13 AM

But is there a way of making it so that if cell is blank it doesn't add the conditional formatting?

**NBVC** · 02-11-2009, 11:19 AM

Originally Posted by Back2Basics

But is there a way of making it so that if cell is blank it doesn't add the conditional formatting?

See attached

**Back2Basics** · 02-11-2009, 11:22 AM

Right Okay, I thought i tried that. Thanks again.

I didn't realise that the conditions were in order of importance, now I know dun I.

**NBVC** · 02-11-2009, 11:24 AM

Yes, with Conditional Formatting, each condition is checked consecutively.. as soon as a condition is met.. it applies that format and stops....so you have to be careful the order you write the conditions in... just like a normal nested IF() formula....