Format font colour to change
Solved/Closed
jandc111
jandc111
- Posts
- 2
- Registration date
- Thursday May 25, 2017
- Status
- Member
- Last seen
- May 26, 2017
jandc111
- Posts
- 2
- Registration date
- Thursday May 25, 2017
- Status
- Member
- Last seen
- May 26, 2017
Related:
- Format font colour to change
- Changing font colour ✓ - Forum - Office Software
- Excel change font colour based on value ✓ - Forum - Excel
- Setting the window colour will change the colour of ✓ - Forum - Windows
- Windows 10 font size suddenly changed - Guide
- Date format in excel not changing - Guide
1 reply
Mazzaropi
May 25, 2017 at 02:12 PM
- Posts
- 1963
- Registration date
- Monday August 16, 2010
- Status
- Contributor
- Last seen
- April 25, 2022
May 25, 2017 at 02:12 PM
Jerry, Good afternoon.
You must use the Conditional Format to have what you need.
Select K2:K15 to apply the CF.
Menu Conditional Format
Using Formula
=K2>$L$2
Select colour format as desired
OK
Please, tell us if it worked as you desire.
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
You must use the Conditional Format to have what you need.
Select K2:K15 to apply the CF.
Menu Conditional Format
Using Formula
=K2>$L$2
Select colour format as desired
OK
Please, tell us if it worked as you desire.
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
May 26, 2017 at 12:26 PM