I need to make certain cells on a report highlighted based on 2 conditions from raw data.

Basically what I need is:

**If the date in range V2-V400 is today, AND the number in range Y2-Y400 is the same as say A2, then I need A2 to be highlighted.**

I've been told by a colleague that conditional formatting is the best option, but they couldn't help me with a formula.

And I have never used conditional formatting let alone with 2 conditions that need to be met.

Please can anyone help me out?

Thank you so much in advance!