Combo Box Question

[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



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




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

 

[Rick]

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 ?

 

[bubear99]

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.



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




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

 

[Dave Peterson]

With my combobox linked to A1. I selected my Range (C1020 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.