S Sharon Feb 12, 2009 #1 On conditional formatting for dates, say I need dates between 1/1/09-4/30/09 to turn red. Can this be done?
On conditional formatting for dates, say I need dates between 1/1/09-4/30/09 to turn red. Can this be done?
M muddan madhu Feb 12, 2009 #2 condition 1 : formula is : =AND(A1>=DATE(2009,1,1),A1<=DATE(2009,4,30))