Home » Questions » Computers [ Ask a new question ]

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: 55
Total answers/comments: 2
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: