Change color to different cells based on another cells text.
Solved/Closed
Hi, need some help, cannot figure this one out. I had attempted to use conditional formatting; however, it is not completely accomplishing what I have in mind.
I want to know how to change color to different cells based on another cells text. For example, if I change or add a text word "Pass" to cell F1, I would want cell F1 to turn green and automatically have B1 turn blue. In the same token, if I change F1 to "Fail", I would want F1 to turn red and have B1 to turn red.
Any info you can provide will be great.
P.S. I had tried to subscribe to CCM; however, there is an error code on CCM that is not allowing me to submit. The error I am receiving when clicking submit is "object, object".
I want to know how to change color to different cells based on another cells text. For example, if I change or add a text word "Pass" to cell F1, I would want cell F1 to turn green and automatically have B1 turn blue. In the same token, if I change F1 to "Fail", I would want F1 to turn red and have B1 to turn red.
Any info you can provide will be great.
P.S. I had tried to subscribe to CCM; however, there is an error code on CCM that is not allowing me to submit. The error I am receiving when clicking submit is "object, object".
Related:
- Excel change text color based on another cell
- Excel change font color based on value - Best answers
- Excel if change color - Best answers
- Based on the cell values in cells b77 ✓ - Excel Forum
- Notepad++ change background color - Guide
- Html text color - Guide
- How to change date format in excel - Guide
- Based on the values in cells b77 ✓ - Excel Forum
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Oct 7, 2015 at 01:51 PM
Oct 7, 2015 at 01:51 PM
conditional formatting is what you want to do. when you say it did not work, what did not work for you ?
Oct 7, 2015 at 02:02 PM
I chould not figure out how to have cell F1 turn green and have B1 automatically turn blue by inputting text "Pass" in F1. I was only able to have F1 turn green when inputting text "Pass" into it but was not able to have B1 turn blue automatically. So I have limited knowledge in expanding conditional formatting to do want I have in mind.
Oct 7, 2015 at 02:08 PM
in B1you can have some thing like
=F1="Pass"
and choose blue color
Oct 7, 2015 at 02:47 PM