Excel Forum

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.