View Single Post
 
Old 12-05-2014, 11:47 AM
Phil H Phil H is offline Windows XP Office 2003
Advanced Beginner
 
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