View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Karen Karen is offline
external usenet poster
 
Posts: 447
Default Event Change code

I want to be able to track changes made to a spreadsheet by users by changing
the colour of the cells.

worksheet name is cost by vehicle and the range that needs to be covered is
G1:k800. I'd like any cells changed to change to a red background.

I know this is a worksheet change event, but I don't have any idea how to do
it. Can anyone point me in the right direction please.