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
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!
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:
- How to change font colour in conditional formatting
- Excel conditional formatting text color - Best answers
- Excel change text color based on value - Best answers
- How to change font in notepad++ - Guide
- How to change date format in excel - Guide
- How to change language in kmplayer - Guide
- Pdf to word tamil font ✓ - Word Forum
- Crimping colour code - Guide
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
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!
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!
Mar 18, 2013 at 11:09 PM
how is that.
any help?
Mar 19, 2013 at 09:02 PM