Hi everyone , I might be trying to do the impossible but .... I have a spreadsheet that needs me to enter the date in a cell and information updates . I then need to recolour the font manually to make it easier for any reader to see any updates . The colour is not important as long as it is different from the previous entry .Is it possible to make this change automatically ?
Anybody got any ideas ?
You will have to use VBA code to accomplish this.
This simple bit of code will alternate between red and blue font color each time a cell in the range of A1:A100 is changed.
This code goes into worksheet module. Adjust the range reference to suit.
Please Login or Register to view this content.
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks