Previous Topic Next Topic

Format font colour to change

Solved/Closed
jandc111 Posts 2 Registration date Thursday 25 May 2017 Status Member Last seen 26 May 2017 - 25 May 2017 à 11:03
jandc111 Posts 2 Registration date Thursday 25 May 2017 Status Member Last seen 26 May 2017 - 26 May 2017 à 12:26
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

Réponse 1 / 1
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 147
25 May 2017 à 14:12
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
jandc111 Posts 2 Registration date Thursday 25 May 2017 Status Member Last seen 26 May 2017
26 May 2017 à 12:26
Worked great! Thank you!!