Thread: [Solved] Conditional Formatting with Dates
View Single Post
 
Old 02-21-2013, 03:42 AM
Kevin@Radstock Kevin@Radstock is offline Windows 7 32bit Office 2010 32bit
Office 365
  
Join Date: Feb 2012
Posts: 94
Kevin@Radstock is on a distinguished road
Default
Hi namedujour

Assuming your data that you want apply the conditional formatting to, is in column A.
Select the column or the range of cells you wish to apply the formatting. Home tab > Conditional Formatting > New rule > Use a formula etc > Use the formula below in the box "Format values where this formula is true: > Apply the required formatting > OK

=AND($A1<>"",$A1<DATE(YEAR(TODAY())-1,MONTH(TODAY()),DAY(TODAY())))
Reply With Quote