Hi everyone!
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!
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!