condition format on date and contents

[mart1000]

I want to conditionally format a whole column in a sheet so if the data held is less than today it will change colour


eg
Format > Conditional Formatting
1st box as "Cell Value Is"
2nd box "Less Than"
3rd Box - type =Today()

fill format Pink

BUT the trouble is I want to exclude those rows where no date entered and it shows these as Pink, I only want to test cells specifically where I have entered a date value

 

[strongm]

There are a couple of ways of dealing with that. probably the most straightforward is to add a new rul;e that applies to the same range, but placed above the existing rule that applies No Format is the cell is empty (=""), and then stops processing conditional rules for that cell (Stop if True), e.g

 

[mart1000]

cheers, worked fine . I was tryin exactly what you had except instead of "" I was putting in NULL

 

[Andrzejek]

mart1000,
You should reward strongm with a Star - click on [blue]Great Post![/blue] in his post.

---- Andy

"Hmm...they have the internet on computers now"--Homer Simpson