I need cells in Excel to be highlighted if they contain 2017 in the date. For instance there is a column that has just dates. Some dates are for 2017. I need to input those dates at a later time.
The column with approved vacation for the year and includes some dates for 2017. I've tried the Highlight Cell with text that contains "2017", "m/dd/2017", "mm/dd/2017". What am I doing incorrectly?