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
Related:

1 response

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 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