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.

[skeets]

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 😎

[modis]

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

[sghaua]

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

[dbmusicproductions]

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.

[acmaarunavachatterjee.]

Very Good Explanation.
Very Very Useful.
Thank You.

[charleswilson]

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

[jimmyboy]

I am assuming Google Sheets does not have this feature.

[Tch]

Ecellent, many thanks. Just what I needed 🙂.

[user_skjdji]

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