I'm building labor tracking spreadsheet that has every day of the year in it. Some of those days are paid vacation days. I would like to highlight the rows of those particular dates (not a range), in order to make certain the hours entered in those rows stand out (like in green, or whatever). I have a list of holiday dates (in long date format). I would like to use that list in order to find those dates in my main date column (also all displayed in long date), and then highlight the rest of that row. Help would be much appreciated
How it works:
- Select the list of Holidays, including header (Dates, Check Screen Shot).
- Press Ctrl+Shift+F3.
Create Names From Selection, check the
TOP ROW& finish with Ok.
- Reach to
Conditional Formatting Commandand hit
- Write this Formula.
N.B. In the Formula,
Holidays is the Name Excel assigned to Holiday's Date list.
- Apply an appropriate Format & finish with
You find the Dates are now highlighted as matched with list of Holidays (Dates).
Adjust cell reference and the Holidays list as needed.