Report

Format font colour to change [Solved]

Ask a question jandc111 2Posts Thursday May 25, 2017Registration date May 26, 2017 Last seen - Last answered on May 26, 2017 at 12:26 PM by jandc111
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
Helpful
+1
plus moins
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
Was this answer helpful?  
jandc111 2Posts Thursday May 25, 2017Registration date May 26, 2017 Last seen - May 26, 2017 at 12:26 PM
Worked great! Thank you!!
Reply
Leave a comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!