View Single Post
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default

activecell.interior.colorindex = 3

sets it to red

--
HTH

Bob Phillips

"anthony" wrote in message
...
could some one please tell me how in a visual basic macro i can change the
background colour of a cell.