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!

45
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?
0
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
0