u/Adventurous_Fox9585

Hi all, I'd be really grateful for some help, please!

I have two spreadsheet tabs with URLs in column F

I want to highlight cells red in column F of spreadsheet 2 if the link in the cell matches ANY link from column F of spreadsheet 1 (called April 2026).

So far, I think I've worked out that I need to use conditional formatting with a vlookup formula. This is the formula I have so far, but it just says "invalid formula" when I try it:

=VLOOKUP(F2, INDIRECT(‘April 2026’!F2:F), 6, FALSE)

I know I've made a ton of mistakes there and have looked at videos/other answers elsewhere, but can't fix my issue! Thank you in advance if you can help!