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/
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.
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
No comments:
Post a Comment