Microsoft Office Forums - View Single Post - Conditional Formatting Dates

Thread: Conditional Formatting Dates

View Single Post

Old

12-05-2014, 11:47 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

Conditional Formatting Dates

Cell C2 has a future date in it (1/6/2015).

Range N5:N51 holds various dates. I need to conditionally format the range with a formula like =(=<C2-1097), to format the cells for dates equal to or before 1/6/2012. What would the formula be?

Reply With Quote