Conditional Formatting - Multiple Conditions

[eoinymc]

Hi,

I am using a form control combo box, which returns a number (1-13), depending on what option I've chosen.

I then have an index/match lookup for month by month results based on this...

My problem is:
2 of the options (5 & 9) are percentages, so I want to format the cells to be numbers when these two aren't chosen and percentages when they are.

So, I had two conditional format rules for this:
=or($B$5=5,$B$5=9), format as percentage
=or($B$5<>5,$B$9<>9), format as number

Whichever formatting rule is first takes precedence and even when I choose another option, the formatting of the cells do not change...

Anyone got any ideas as to why this is? Or can they give me another idea of how to get around this?

Thanks,

Eoin

 

[alvin-chung]

Hi Eoin,

Seems to me that your combo box is link to cell $B$5?
If that's the case your conditional formatting shall work on the range that you selected, but not on the combo box, i.e. if you've selected range =$B$5 for your conditional formatting, try move the combo box to somewhere else and you'll see what I mean

Probably the only way to display the % for specific option(s) in combo box is having the original list appeared as %, else might need vba I guess...