Excel Forum
Similar Content
Highlight and Sort the Top and Bottom Performers in a List in Excel
Tutorial: How to highlight the rows of the top and bottom performers in a list of data. This allow...
Multiple Conditional Formatting Rules for a Cell in Excel
Tutorial: Apply multiple Conditional Formatting rules to a cell or range in Excel. This allows you ...
Get the Last Day of the Month in Excel
Tutorial: How to get the last day of the month, including the date and day of week, for any date in ...

Excel Magic Trick 633: Conditional Format Dates for Year From A List Of Dates With Different Years

See how to create Conditional Formatting that will highlight the dates within a given year using the Year Function and Mixed Cell References in a Logical TRUE FALSE formula.

Got a Question? Ask it Here in the Forum.