Microsoft Office Forums - View Single Post - Conditional Formatting Dates

Thread: Conditional Formatting Dates

View Single Post

Old

12-08-2014, 05:57 AM

Phil H

Phil H is offline

Phil H uses Windows XP

Windows XP Phil H uses Office 2003

Phil H uses Office 2003

Office 2003

Advanced Beginner

The original poster

Join Date: Jun 2010

Posts: 81

Phil H is on a distinguished road

Default

Pecoflyer, Got rid of the error with: =$N5<=DATE(YEAR($C$2-3),MONTH($C$2),DAY($C$2)), but now all dates are coming up formatted - the formula is saying every date is TRUE, which is incorrect.

Reply With Quote