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
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.
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:
- How would you change all cells containing the word pass to green
- Excel if cell color is green then - Best answers
- Excel formula to change font color without conditional formatting - Best answers
- Word apk for pc - Download - Word processors
- Word watermark on all pages - Guide
- How to change close friends story to public - Instagram Forum
- How to change free fire facebook account to google account - Guide
- Number to text in word - Guide
1 response
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Jul 17, 2015 at 03:04 PM
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
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