• 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

    Hui...

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

Quick one on Cell Value Changes

Busymanjohn

Busymanjohn

Member
Hi guys, I've been looking for a simple macro ( or formatting if possible ) that will change the colour of cells within a worksheet when the value is changed .... this will need to encompass a large area of data, in addition I need to reset those changed cells to No Fill once all the updates have been completed ( close loop ).
 
Have you tried Conditional Formatting

http://chandoo.org/wp/2008/03/13/want-to-be-an-excel-conditional-formatting-rock-star-read-this/
 
You must log in or register to reply here.
Back
Top