Thread: change color of a range of cels in a row based on the value in one
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Srajes Srajes is offline
external usenet poster
  
Posts: 9
Default change color of a range of cels in a row based on the value in one
Hi, I want to automatically change the color of a range of cells when a user
select a specific word from a drop-down list in a cell in that range of cells.

For example: user selects 'FIVE' would change the color of the cells
1,2,3,4,5(FIVE).

1 2 3 4 FIVE


Appreicate any help to implement this.
Thanks


Reply With QuoteReply With Quote