Howdy All,
I have a date cloumn that is of a custom cell format of 'mm/yyyy', I would like to set up a conditional format rule such that if the month is between this month and 2 months ago it is green, if the month is 3 months ago it is yellow, and 4 or more months is red. I can get it to sort of work using the "date" is "last month" canned rule but can't figure out how to do the 60/90/120 day splits. Just to throw another monkey wrench in to things there are blank and header cells in the column that I would like to not format. Any help will be greatly appreciated
Excel 2010
--Kevin
Bookmarks