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.