Condition formatting on changing cell color based on another cel [Closed]

Report
Posts
1
Registration date
Friday July 17, 2015
Status
Member
Last seen
July 17, 2015
-
Posts
1852
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
November 7, 2020
-
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.

1 reply

Posts
1852
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
November 7, 2020
136
Saitoh7, Good afternoon.

Try to do:

Select A2.
Menu Conditional Format
Formula

Rule 1
=A1="PASS"
Format as GREEN

Rule 2
=A1="FAIL"
Format as RED
OK

Is that what you're looking for?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão

Newsletter

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!