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

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

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

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?


--
gjcase
------------------------------------------------------------------------
gjcase's Profile: http://www.excelforum.com/member.php...o&userid=26061
View this thread: http://www.excelforum.com/showthread...hreadid=528476