Sunday, December 2, 2012

yogi_WorkAround For Conditional Formatting To Include More Than One Condition Per Rule

                                          Google Spreadsheet   Post  #904
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI    Dec 1, 2012
user Nude_Lewd_Man said:(                             !category-topic/docs/spreadsheets/q3HlZgtRWps)
Conditional formatting, how can I include more than one condition per rule..?

I've got a spreadie where I've replicated one page off to demonstrate:

Basically, we have a number of sites/depots that are dotted around the world, and I would like to use conditional formatting to change the text colour to make it easier to see which region that depot is in. Unfortunately, we have so many depots that I can't just add each one to use a rule for itself (tried that, only got EMEA, Canadia and the first of the APAC depots done...then ran out of rules) which doesn't really help as much as I'd like...

I then tried to use multiple entries/conditions to one rule (as in '"London" or "Amsterdam" or "Dresden" or...') but that then borked the whole rule - presumably as it was looking for all the depot names in the correct order, each with the quote marks and all in one cell..

I've taken a quick snip to try to show the example I've currently got running, which can be seen here:

Anyone have any ideas as to how I can get this sorted..?

Please advise.

Kind regards,



As of now (Dec-02-2012) Google spreadsheet does not support Conditional Formatting to include more than one condition per rule ... so I propose the following workaround