View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
shawn lee shawn lee is offline
external usenet poster
 
Posts: 1
Default Change the background color of cells once it being edited



Hi all, wondering if you all have any solutions for changing the
background color of cells once its being edited .

For example, I have a monthly report in excel for the month of August.
Then when it comes to September, I will need to do some changes to it.
The macro will run and color the cell background to all those cells
that are edited (different from August).

Then in October, the same thing happens again. Any bright ideas?

*** Sent via Developersdex http://www.developersdex.com ***