I am trying to find the right formula for the below situation. Not sure if conditional formatting is the answer or a formula or a combination. I have reviewed guidance for how to use IF and IFS as well as how to do conditional formatting based on another cells value but nothing has worked.