CODEWITHSUNDEEP
excelexcel-formulaconditional-formatting
Pankaj Jaju
Pankaj Jaju

Reputation: 5471

Highlight cell if month matches

I need to highlight the Month cell if month matches in the first 4 cells.

enter image description here

For example, in first row I need to highlight E2 rather than E4. If there is no value in the first 4 cells, then i dont need to highlight any of the month cells.

I am trying with conditional formatting, but not able to nail it.

What I want

enter image description here

Upvotes: 0

Views: 1024

Answers (1)

Jean-François Corbett
Jean-François Corbett

Reputation: 38540

This works for me:

=OR((NOT(ISBLANK($A2:$D2))*(MONTH($A2:$D2)=E$1))>0)

enter image description here

enter image description here

Upvotes: 1

Related Questions