Conditional Formatting: Change fontcolor based on another cell [Solved/Closed]

wandanuila 1 Posts Thursday February 21, 2013Registration date February 21, 2013 Last seen - Feb 21, 2013 at 05:11 PM - Latest reply:  EV-SouthAfrica
- Jun 9, 2017 at 04:03 AM
Hello,

I have "text" in cell B1. However, I want the font color to change based on the numerical value in cell B8; so if the number in cell B8 ranges between 1-10 I want the text in B1 to change to GREEN; if the number in B8 ranges 11-20 I want the text in B1 to change to BLUE; if the number in B8 is greater than 20 I want the text in B1 to change to RED.

Is this possible?

thank you so much



See more 

17 replies

Zohaib R 2416 Posts Sunday September 23, 2012Registration date November 12, 2017 Last seen - Feb 22, 2013 at 08:54 AM
+42
Helpful
Hi wandanuila,

Please use the below mentioned steps to use a formula in conditional formatting to define the rule:

1. Select the cell B1.
2. Click Conditional Formatting from the top ribbon.
3. Select New Rule.
4. Click Use a formula to determine which cells to format.
5. Enter the below mentioned formula in Format values where this formula is true: =AND(1<=$B$8, $B$8<=10)=TRUE
6. Click "Format" and select the Fill Color as Green.
7. This formula will change the back color of Cell B1 to green if the value is from 1 to 10.
8. To change the back color of Cell B1 to Blue if the value is from 11 to 20 repeat steps 1 through 6, only change the formula in step 5 as:
=AND(11<=$B$8, $B$8<=20)=TRUE
Also select the Fill Color as Blue.
9. To change the back color of Cell B1 to Red if the value is Greater than 20, repeat steps 1 through 6, only change the formula in step 5 as:
=$B$8>20=TRUE
Also select the Fill Color as Red.

For your convenience I have uploaded the sample file here (this file was prepared using Microsoft Excel 2010):

http://speedy.sh/nQqfr/Book1.xlsx

Please revert for clarification.
Was this answer helpful?  
Hi

I know this is outdated but I am trying to do the same thing but with a letter rather than a range of numbers
Osama_bb11 22 Posts Sunday May 25, 2014Registration date September 25, 2014 Last seen - May 25, 2014 at 05:38 AM
thank you , I like it
EV-SouthAfrica - Jun 9, 2017 at 04:03 AM
Thanks - very helpfull
Zohaib R 2416 Posts Sunday September 23, 2012Registration date November 12, 2017 Last seen - Mar 20, 2013 at 03:02 PM
+4
Helpful
Hi,

I apologize to both Rona and rizvisa1 for replying this late to this post. Rona, I have prepared for you an excel sheet which has a drop down in cell A1 to select colors and you will see corresponding change in B1. You can download the sheet from the below mentioned link:

http://speedy.sh/82PHJ/RGBFile.xlsx

I have prepared this sheet using Microsoft Excel 2010. If you have another version of Microsoft Excel, it might not open correctly. If you face any such problem, please reply with the version of Microsoft Excel installed in your computer and I will post the step by step method.

Do reply with results.

Thanks & Regards
Zohaib R
#iworkfordell
If you want to know more about "Formula to Change Font Color", check this link ........

http://www.exceltip.com/tips/formula-to-change-font-color-in-microsoft-excel-2010-2013.html
Thanks Ashish.

I like your link
nurasadim 3 Posts Sunday January 11, 2015Registration date January 12, 2015 Last seen - Jan 12, 2015 at 12:13 AM
0
Helpful
Good job, Thank you so much.