Format font colour to change

Solved/Closed
jandc111
Posts
2
Registration date
Thursday May 25, 2017
Status
Member
Last seen
May 26, 2017
- Updated on May 25, 2017 at 04:38 PM
jandc111
Posts
2
Registration date
Thursday May 25, 2017
Status
Member
Last seen
May 26, 2017
- May 26, 2017 at 12:26 PM
Hello,

Using Excel, I have a range of cells K2-K15 that contain numeric values and I want the font color to change in any of those cells that are greater than L2. Can this be done?

Thanks,
Jerry

1 reply

Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
147
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
1
jandc111
Posts
2
Registration date
Thursday May 25, 2017
Status
Member
Last seen
May 26, 2017

May 26, 2017 at 12:26 PM
Worked great! Thank you!!
0