Formatting

[Guest]

Hi,

Im sure this is quite simple but i cant seem to get it to work, i have
created a list box with data validation that contains about 30 entries, i
want to use conditional formating to change the background cell colour. I can
do it by using cell value is equal to ="London" and this will turn the cell
blue when London is selected from the list. The list can only be 1 of 2
colours blue or orange but how do i specify the cell formatting for 30
possible entries into that cell.

 

[gjcase]

You don't need formatting for 30 enteries; you just need ="London" an
<>"London" . In fact, the first alone will probably work if you set th
default format to orange.

---GJ

 

[Guest]

I understand what you are saying, but around 12 cities are to be blue if
selected and the other 18 orange if selected from the same list, if i use
just ="London" it works but how do i say ="London + Birmingham + Manchester
etc etc, thanks in advance.

 

[gjcase]

I guess I'm not sure what you mean. How is the concatenated list
created? Is London always first? Or is your condition that a long
string of indeterinate length contains "London" somewhere within it?