With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Sunday, December 2, 2012
yogi_WorkAround For Conditional Formatting To Include More Than One Condition Per Rule
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..