• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to format a cell color if a particular value is changed in the entire text?


New Member
I want to know if there is any way to set a formula to change the cell color; for example I've entered Date & Time in a particular cell and I work on that sheet everyday. Now what I want is if I change the date to 31 of any month the cell color should change to red. Is there any way???


Excel Ninja
Staff member

Have you tried Conditional Formatting

If you have a Range of Dates for your months lets say C3:N3

Select the Range

add a Conditional Format, use a Formula


Set the format style (Red)



New Member

I tried Conditional Formatting as well but it didn't work.

Thanks for the help this worked.