Conditional Formatting Combo Box Issue


G

Guest

Hi there,

I've got two combo boxes setup, one which has 3 initial options and a second
which has further options based on the selection made in the first. In total
this gives me 6 final options.

The second Combo Box outputs numbers 1 to 6 in the selected cell as expected.

My issue is that I want to use conditional formatting to link to the number
output by the second combo box to colour other cells. I've been reading on
here and know how the formula works etc but for some reason the conditional
formatting doesn't want to recognise the number output by the second combo
box and therefore does not work!

Is there any way around this or am I missing something?!

Thanks in advance.
 
Ad

Advertisements

S

Stefan B Rusynko

Conditional formatting in what program
FrontPage does not have conditional formatting

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


| Hi there,
|
| I've got two combo boxes setup, one which has 3 initial options and a second
| which has further options based on the selection made in the first. In total
| this gives me 6 final options.
|
| The second Combo Box outputs numbers 1 to 6 in the selected cell as expected.
|
| My issue is that I want to use conditional formatting to link to the number
| output by the second combo box to colour other cells. I've been reading on
| here and know how the formula works etc but for some reason the conditional
| formatting doesn't want to recognise the number output by the second combo
| box and therefore does not work!
|
| Is there any way around this or am I missing something?!
|
| Thanks in advance.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top