Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel
Previous Topic Next Topic

Format font colour to change [Solved/Closed]

Report
Posts
2
Registration date
Thursday May 25, 2017
Status
Member
Last seen
May 26, 2017
 -
Posts
2
Registration date
Thursday May 25, 2017
Status
Member
Last seen
May 26, 2017
 -
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

Answer 1 / 1
Posts
1926
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
June 12, 2021
 143
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
Thank you
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Report
Posts
2
Registration date
Thursday May 25, 2017
Status
Member
Last seen
May 26, 2017
Worked great! Thank you!!
Ask a question

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!