I am trying to write a custom formula to conditional format column E by referring to the different tenure level targets in column D to indicate if they are hitting their targets base off of their tenure level. I wrote the formula below and it didn't come out right. Any help would be greatly appreciated.
Trying to say:
If D3 = "new" or "beginner" or "intermediate" or "veteran",
Then F3 >= D24 or F3 >= D25 or F3 >= D26 or F3 >= D26.