hi, wanted to check if it's possible to do condition formatting on cell color based on another cell's text.
For example I have cell A1 with Text Pass. Cell A1 already has conditional formatting for text "PASS" = cell color green, and text "FAIL" = cell color red. On the other hand, I have cell A2 which has some details in it and already contains a formula. I want to base A2's cell color with A1. If A1 = PASS and A1 cell color is green, then A2 cell color will be Green too. If A1 = FAIL and A1 cell color is Red, the A2 will cell color will be Red too.
Hope the description is not complicated. Thanks in advance for any advice given.
Excel if pass green fail red
Excel pass green fail red - Best answers
Change cell color if condition fails - Best answers