Hi, need some help, cannot figure this one out. I had attempted to use conditional formatting; however, it is not completely accomplishing what I have in mind.
I want to know how to change color to different cells based on another cells text. For example, if I change or add a text word "Pass" to cell F1, I would want cell F1 to turn green and automatically have B1 turn blue. In the same token, if I change F1 to "Fail", I would want F1 to turn red and have B1 to turn red.
Any info you can provide will be great.
P.S. I had tried to subscribe to CCM; however, there is an error code on CCM that is not allowing me to submit. The error I am receiving when clicking submit is "object, object".