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
Related:
- Excel formula to change font color without conditional formatting
- How to change font colour in conditional formatting - Best answers
- Excel conditional formatting text color - Best answers
- Number to words in excel formula without vba - Guide
- How to change date format in excel - Guide
- Excel grade formula - Guide
- 1st, 2nd, 3rd position formula in excel ✓ - Office Software Forum
- Notepad++ change background color - 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