Formatting

[Baggie79]

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.
--
Baggie79

[gjcase]

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

---GJC

[Baggie79]

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.
--
Baggie79


"gjcase" wrote:

>
> You don't need formatting for 30 enteries; you just need ="London" and
> <>"London" . In fact, the first alone will probably work if you set the
> default format to orange.
>
> ---GJC
>
>
> --
> gjcase
> ------------------------------------------------------------------------
> gjcase's Profile: http://www.excelforum.com/member.php...o&userid=26061
> View this thread: http://www.excelforum.com/showthread...hreadid=528476
>
>

[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?