This was going to post a quality thread about how you can create conditional formatting for arbitrary strings without having to make individual rules for each string you want formatted. Specifically, by using VLOOPUP to lookup an ID associated with the unique strings in a separate admin tab, then hiding the column with the IDs pulled from that tab. But, this would only work if Google Sheets supported conditional formatting color scales based on values in other cells.
Google please read.
Thanks.
Download more RAM. 🐏 ⨉ 0Posted by August R. Garcia 3 years ago
Edit History
• [2018-12-19 9:48 PST] August R. Garcia (3 years ago) 🕓 Posted at 19 December, 2018 09:48 AM PST
Hire freelancers and/or advertise your goods and/or services. Hire people directly. We're not a middleman or your dad. Manage your own business transactions.
Forum in Spreadsheets | By August R. Garcia
Published | Last Update
592 views, 0 RAMs, and 0 comments
This was going to post a quality thread about how you can create conditional formatting for arbitrary strings without having to make individual rules for each string you want formatted. Specifically, by using VLOOPUP to lookup an ID associated with the unique strings in a separate admin tab, then hiding the column with the IDs pulled from that tab. But, this would only work if Google Sheets supported conditional formatting color scales based on values in other cells.
Google please read.
Thanks.
Edit History
• [2018-12-19 9:48 PST] August R. Garcia (3 years ago)🕓 Posted at 19 December, 2018 09:48 AM PST
Sir, I can do you a nice SEO.
Post a New Comment
To leave a comment, login to your account or create an account.
Do you like having a good time?
Register an Account
You can also login to an existing account or reset your password. All use of this site is subject to the terms of service and privacy policy.
Read Quality Articles
Read some quality articles. If you can manage to not get banned for like five minutes, you can even post your own articles.
View Articles →
Argue with People on the Internet
Use your account to explain why people are wrong on the Internet forum.
View Forum →
Vandalize the Wiki
Or don't. I'm not your dad.
View Wiki →
Ask and/or Answer Questions
If someone asks a terrible question, post a LMGTFY link.
View Answers →
Make Some Money
Hire freelancers and/or advertise your goods and/or services. Hire people directly. We're not a middleman or your dad. Manage your own business transactions.
Forum— Read More
Find more related content below!