software

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 =quot;Londonquot; 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 =quot;Londonquot; and
lt;gt;quot;Londonquot; . In fact, the first alone will probably work if you set the
default format to orange.

---GJC--
gjcase
------------------------------------------------------------------------
gjcase's Profile: www.excelforum.com/member.php...oamp;userid=26061
View this thread: www.excelforum.com/showthread...hreadid=528476I 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 =quot;Londonquot; it works but how do i say =quot;London Birmingham Manchester
etc etc, thanks in advance.
--
Baggie79quot;gjcasequot; wrote:

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


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 quot;Londonquot; somewhere within it?--
gjcase
------------------------------------------------------------------------
gjcase's Profile: www.excelforum.com/member.php...oamp;userid=26061
View this thread: www.excelforum.com/showthread...hreadid=528476