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.