Format font colour to change [Solved/Closed]

jandc111 2 Posts Thursday May 25, 2017Registration date May 26, 2017 Last seen - May 25, 2017 at 11:03 AM - Latest reply: jandc111 2 Posts Thursday May 25, 2017Registration date May 26, 2017 Last seen
- 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
See more 

2 replies

Best answer
Mazzaropi 1831 Posts Monday August 16, 2010Registration dateContributorStatus May 21, 2018 Last seen - May 25, 2017 at 02:12 PM
1
Thank you
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

Thank you Mazzaropi 1

has helped 2134 users this month

jandc111 2 Posts Thursday May 25, 2017Registration date May 26, 2017 Last seen - May 26, 2017 at 12:26 PM
Worked great! Thank you!!