Highlight Excel VBA Formula

Question

I create an event manager with data in column A60: A150 (event name) B60: b150 (start date) and C60 - c150 (end date) D60 - D150 (place) when I enter the data in the cells, the event name appears in the calendar

I want if the value in column D60: D150 is ABC, the dates should be green or any color

According to the Red Bull image, Green should be highlighted, and the AAA should be a different color if this Station / Place event is different.

i use this formula

= D60: d150 = "ABC"

color is green and select the range B3: AF50, but it changes the color of cell b3 off-date

Answer 1

Use this formula instead:

=VLOOKUP(B3,$A$60:$D$150,4,FALSE) = "ABC"

A60: A150. , ​​/. , "ABC" True, .

VLOOKUP "ABC", False.