Highlight dates within a date range using conditional formatting
Filed in Excel on May.10, 2009. Email This article to a Friend
Question: How do I highlight dates that meet a criteria using conditional formatting?
Answer:
How to apply the conditional formatting formula in excel 2007:
- Select the range (A1:A20)
- Click "Home" tab on the ribbon
- Click "Conditional formatting"
- Click "New rule..."
- Click "Use a formula to determine which cells to format"
- Click "Format values where this formual is true" window.
- Type =IF((A1<$D$2)*(A1>$D$1), TRUE, FALSE)
- Click Format button
- Click "Fill" tab
- Select a color
- Click OK!
- Click OK!
Try changing dates in D1 and D2 and see different cells highlighted in column A.
To include the the start and the end date into the conditonal formatting formula, try this:
=IF((A1<=$D$2)*(A1>=$D$1), TRUE, FALSE)
Download excel example file
highlight-dates-in-range-using-conditional-formatting.xls
(Excel 97-2003 Workbook *.xls)
Functions in this article:
IF(logical_test;[value_if:true];[value_if_false])
Checks whether a condition is met, and returns one value if TRUE, and another value if FALSE
Related blog posts
- Highlight duplicates where an adjacent column is in a date interval using conditional formatting in excel
- Highlight duplicates using conditional formatting in excel
- Highlight the second or more duplicates in two lists using conditional formatting in excel
- Highlight duplicate values in a range using conditional formatting in excel
- Highlight duplicates where adjacent cell value meets criteria using conditional formatting in excel








Leave a Reply