This article goives a good exmple for conditional formatting programmatically:
Setting Conditional Formatting in Excel 2007
DD Says...Rick, I use this quite a lot, but if I borrow your brain, I have not found out a way of doing it for dates.
That is, if a date is over 60 days, I would like that cell highlighted.
I can only do it by a macro, not CondForming, unless you know better?
Dave, You can use Today()-60 with a "less than" rule. Rick
DD...Do you know that was so obvious it never occurred to me? :~