Conditional formatting: change fontcolor based on another cell

Solved/Closed
wandanuila Posts 1 Registration date Thursday February 21, 2013 Status Member Last seen February 21, 2013 - Updated on Jan 29, 2019 at 09:05 AM
 Ravi - Jan 3, 2022 at 07:42 PM
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!
System Configuration: Windows 7 / Internet Explorer 9.0
Related:

3 responses

Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 69
Updated on Jan 29, 2019 at 09:06 AM
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.

Please revert for any clarification!

what will I do to change the font color of the data cell using dropdown list. I mean for example in A1 where the dropdown list is created I chose red . how will the data cell in B1 turns red also and if I chose again green the data will change also.
how is that.
any help?
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Mar 19, 2013 at 09:02 PM
same as above