Thread
:
HOW TO CHANGE CELL COLOR ONCE ITS BEING EDITED
View Single Post
#
2
Posted to microsoft.public.excel.programming
Nigel[_2_]
external usenet poster
Posts: 735
HOW TO CHANGE CELL COLOR ONCE ITS BEING EDITED
Is this why you posted the same question twice but not in a different
color?!
Try using the change event for the cell(s) in question, you will need to
reset the cells to a neutral color first, maybe use a control button, then
as each cell is changed trigger a color change.
--
Regards,
Nigel
"Shawn lee" wrote in message
...
Hi all,
Any good solutions to change cell color onces its being edited?
For example, I have a monthly report in excel format. In August all the
results are filled in. Then comes September, when I change the numbers
or words, those cells that are different (Edited) from August will have
a cell color changed say maybe yellow or blue. So as to differentiate
from those that are not edited. I know of the function in excel which is
Track Changes. I want something like that, but I want the cell to change
color and not highlighting it only.
So any one have any bright ideas to this? Thanks
*** Sent via Developersdex
http://www.developersdex.com
***
Reply With Quote
Nigel[_2_]
View Public Profile
Find all posts by Nigel[_2_]