Excel: Finding a value in a range of values

Excel: Finding a value in a range of values In my Excel document, I have one sheet containing a column of important dates. In another sheet I have a list of all dates. I want to conditionally format that list such that if the date is present in the important dates column, it is highlighted.
Asked by: Guest \| Views: 209

Total answers/comments: 2

Comments display order:

Guest [Entry]

"Apply the following conditional Formatting rule formula to your list of all dates:

=VLOOKUP(D1,A$1:A$5,1,FALSE)

Where ""D1"" is the cell-reference of the first cell in the all-dates range,
and ""A$1:A$5"" is the important-dates range (be sure to add the Workbook and Sheet references),

This assumes vertical lists of course."

Guest [Entry]

Sorry for the images as an answer, but it's faster for me: