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     www.energyefficientbuild.com.    Dec 1, 2012
user Nude_Lewd_Man said:(                                       http://productforums.google.com/forum/#!category-topic/docs/spreadsheets/q3HlZgtRWps)
Conditional formatting, how can I include more than one condition per rule..?
Hi,

I've got a spreadie where I've replicated one page off to demonstrate:
https://docs.google.com/spreadsheet/pub?key=0AmsJVtMcG2QwdGhIN3lTWWRZQmZzVVMtdFJLVk9ZWHc&output=html

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:
http://www.Nude-Lewd-Man.co.uk/Misc_Pics/_TEMP_.JPG

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

Please advise.


Kind regards,

N_L_M

--------------------------------------------------------------------------------------------

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