How to automatically change font colour based on cell value in Excel

This tutorial shows you how to automatically change font colour based on cell value in Excel. Watch till the end to see how the font colour changes when we change the value in the cell.

[@charleswilson3493]

So simple but why I found no one else that could show me this no matter how long I have searched is beyond me...thank you so much

[@sabrinafahad]

You’re most welcome! Glad it helped.

[@user-fe6mg7ns4i]

I WAS LOSING MY MIND!!
Spent the last hour trying to figure this out. After a few minutes on your video, I got it!
Thank you so much!!!!!

[@skeets347]

In new versions of Excel, conditional formatting isn't the only place but custom formula in format cell also provide same results. More than one way to skin a cat 😎

[@acmaarunavachatterjee.7694]

Very Good Explanation.
Very Very Useful.
Thank You.

[@sabrinafahad]

You’re most welcome 😊

[@modis111]

I wish you had put that LINK below like you said you would

[@dbmusicproductions9181]

What if I want to format a column based on the information in a separate column? So, I want the font color of the column with the name to change based on the data from the column with the number.

[@sghaua]

How can I make the rule that the font changes color if the number results in a negative due to my formula? TIA 🙋🏻‍♀️

[@1234Tch]

Ecellent, many thanks. Just what I needed 🙂.

[@sabrinafahad]

Glad it helped!

[@sangitabhattacharjee5260]

Epic, thank you! ❤

[@jimmyboy1582]

I am assuming Google Sheets does not have this feature.

[@sabrinafahad]

Hi, this is also available in Google Sheets. I’ll post a video soon.