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