Microsoft Office Forums - View Single Post - Conditional Formatting Dates

Thread: Conditional Formatting Dates

View Single Post

Old

12-08-2014, 06:06 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

SOLUTION: =$N5<=DATE(YEAR($C$2-3),MONTH($C$2),DAY($C$2)). The "-3" is interpreted as days in the YEAR expression. If "-3" is replaced with "1097", the formula works.

Reply With Quote