Hello:
Please refer to attached file.
I need CF to highlight date if Column D if it exist in Column A
Let me know if you have any questions.
Thanks.
R
Hello:
Please refer to attached file.
I need CF to highlight date if Column D if it exist in Column A
Let me know if you have any questions.
Thanks.
R
TryFormula:Please Login or Register to view this content.
You’ll need to select cells D2 down before adding the CF formula.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Thanks TMS for the quick
R
Hi,
Select your range and put this formula in Conditional Formatting ---> New Rule--->Use a formula to determine which cells to format
=NOT(ISNA(VLOOKUP(D1,$A:$A,1, FALSE)))
Last edited by Limor_OP; 05-07-2020 at 07:30 PM.
You're welcome. Thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks