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?
|