|  RSS
Subscribe to magazine

PC World Forums: in Excel - how to very color in drop down list? - PC World Forums

Jump to content

Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

in Excel - how to very color in drop down list?

#1 User is offline   cat123 Icon

  • Newbie
  • Pip
  • Group: Members
  • Posts: 2
  • Joined: 15-May 07

Posted 15 May 2007 - 05:32 AM

i have drop down list to select in Excel cell, for ex: Yes, No, N/A. And I want when I select yes -- cell becomes red color, select No - blue and so on..how i can do it?
0

#2 User is offline   KellieCM Icon

  • Expert
  • PipPipPipPipPipPip
  • Group: Members
  • Posts: 3,411
  • Joined: 27-June 07
  • Location:San Francisco, CA

Posted 15 May 2007 - 11:22 AM

That is an interesting question. I know how to do the drop down (and I suspect you do too) but not the automatic color variation. Hmmm...
0

#3 User is offline   cat123 Icon

  • Newbie
  • Pip
  • Group: Members
  • Posts: 2
  • Joined: 15-May 07

Posted 15 May 2007 - 11:41 AM

I got it - use Format>>Conditional formatting. Just one disadvantage - only 3 choices are available
0

#4 User is offline   KellieCM Icon

  • Expert
  • PipPipPipPipPipPip
  • Group: Members
  • Posts: 3,411
  • Joined: 27-June 07
  • Location:San Francisco, CA

Posted 15 May 2007 - 12:56 PM

Interesting... thanks for posting the solution. I love learning new Excel tricks.
0
Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users