Previous Topic Next Topic

Condition formatting on changing cell color based on another cel

Closed
Saitoh7 Posts 1 Registration date Friday July 17, 2015 Status Member Last seen July 17, 2015 - Jul 17, 2015 at 12:44 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Jul 17, 2015 at 03:04 PM
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.
Related:

1 response

Answer 1 / 1
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Jul 17, 2015 at 03:04 PM
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

Similar discussions

How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Conditional formatting: change fontcolor based on another cell
wandanuila -
Ravi -

18 responses
if sum>= 60, color cells red
mindy -
mindy -

4 responses
Highlight cell if another cell contains any text
LvH -
LvH -

4 responses
Excel VBA - Change cell color based on value
Tandar -
ac3mark -

14 responses
Conditional format based on another cell containing text
stakik -
Corrina66 -

5 responses