I need to change a cell's color to green if the current cell content changes in any way. Can this be done?
Thanks in advance for any suggestions!
DonaldJ
I need to change a cell's color to green if the current cell content changes in any way. Can this be done?
Thanks in advance for any suggestions!
DonaldJ
You can use Conditional formatting.
Select the range and from the Home Ribbon select conditional formatting
Select Highlight cell rules
Choose Equal to
And in the dialog type the word that you want to check for.
Change the formatting to whatever you choose.
Regards,
Rudi
Actually rethinking your question...conditional formatting cannot check for if the cell changes (only if a value equals (or does not equal) something).
You will need code to check for ANY type of value change...not just one that meets a set condition.
I will set up an example for you...
Have a look at this sample workbook.
It has some basic code that will capture value changes in cells A1:A10 only.
To see/modify the code, right click on the sheet tab and choose View Code.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks