Combo Box Question

  • Thread starter Thread starter bubear99
  • Start date Start date
B

bubear99

How do I configure a combo box so that when a value is selected, Excel
searches for that value in a range of cells and highlights all
occurences (changes the background/fill color)?


Thanks,

Chris



------------------------------------------------




------------------------------------------------
 
Can't you use conditional formatting ? On the format menu
go to conditional formatting, and format all your cells in
your range that match your value are highlighted ?
 
I've tried to use conditional formatting, but haven't been able to get
that to work either. I linked the combo box to a blank cell and then
used conditional formatting to try to find that value in a range of
cells. However, since all of the values are text, and I'm trying to
find specific words, I'm not sure if I should use "Cell Value Is" or
"Formula Is," assuming that will work at all.



------------------------------------------------




------------------------------------------------
 
With my combobox linked to A1. I selected my Range (C10:D20 for example) with
C10 the activecell, I used formula is:

And this formula:
=C10=$A$1
(excel will adjust the formula for the other cells in the selection. But it'll
always refer to $a$1.)

My combobox was from the controltoolbox toolbar.
 
Back
Top