conditional formatting of date

[bionicle]

Hi all,

I have a column of dates and I need to highlight those dates that are older them 180 days.

so fare I have the following =AND($S2<=TODAY()-180)

the problem I have is that it also highlights the blank cells, what do I need to do / add to make it ignore the blank cells?

thanks

Steve

 

[Joe4]

Understanding that dates are really numbers with special formatting, try:

[COLOR=#333333]=AND($S2<=TODAY()-180,$S2>0) [/COLOR]

 

[bionicle]

Thanks Joe4 simple when you see it in front of you...

 

[Joe4]

You are welcome.