View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Shawn Shawn is offline
external usenet poster
 
Posts: 271
Default Reformat changed cell

I need a VBA code that will cause the formatting of cells A1:A10 to change to
bold, blue if the value of the cell changes.

There are numerical values coded in cells A1:A10 at present. If the user
goes into one of those cells and changes the value to a different value, (say
in Cell A2), I need cell A2 to change its formatting automatically to bold,
blue.

I figure I need a change or change event code.




--
Thanks
Shawn