Thread: change color of a range of cels in a row based on the value in one
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default change color of a range of cels in a row based on the value in one
Excel 2007 or earlier?

Conditional Formatting handles this quite well but earlier versions support
only 3 conditions so if you want 5 choices you would need VBA or Excel 2007.

See help on CF or drop in a Debra's site

http://www.contextures.on.ca/xlCondFormat01.html


Gord Dibben MS Excel MVP

On Fri, 12 Jun 2009 15:54:02 -0700, Srajes
wrote:

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