After an hour or so of messing around with it, I found a Solution!

So you have to have two rules.

First one is Cell is Empty, set the background color to white (not sure why this is needed, but it is crucial for it to work)

Second rule is Custom Formula is =len(B2)>150, set background color to red (this will set it to red if the their is over 150 characters.

This test spreadsheet really helped me out. (gotta make a copy to mess with it)
https://docs.google.com/spreadsheets/d/1ScDqtZvhsmf2iByAuxHBu0-ESpX_TE5pdtBvAxOJ99E/edit#gid=1620525099

Your welcome,
Chris

U7rW8SV

Yes, there are channel markers within the case studies. I think that makes a lot of sense. Thanks for the insight.

My company is a B2B software company and we have A LOT of case studies.  I was doing an audit and rewriting my case study meta data when I thought maybe there was a better way to write the title and meta description for these case studies.

My strategy thus far is to summarize the benefits our software had on the company the case study is about.   Lots of 20% increases,  reached 99% of this metric,  saved 100k in first year.  That kind of stuff.

I wonder if this is the best approach, or if maybe asking questions or just explaining that this is a case study for this company in this industry would be better for SEO.

What do you guys think?  Pardon the redundancy but are there any case studies about seo for case studies?

I have done a good bit of research but am not sure which word to focus on.  I feel that the trend is moving towards no hyphen but I do not have any data to justify that other than google trends.  Here is the research I found:

Google Trends says ecommerce is more popular
http://www.google.com/trends/explore#q=e-commerce%2C%20ecommerce&cmpt=q

Ngram says e-commerce
https://books.google.com/ngrams/graph?content=ecommerce%2Ce-commerce&year_start=1990&year_end=2013&corpus=15&smoothing=3&share=&direct_url=t1%3B%2Cecommerce%3B%2Cc0%3B.t1%3B%2Ce%20-%20commerce%3B%2Cc0

Google Adwords Keyword tool says e-commerce:
e-commerce has 33,100 monthly search volume
ecommerce has 14,800 monthly search volume

What do you think,  will ecommerce overtake e-commerce in the future monthly search volumes?

Ecommerce or E-commerce?

After an hour or so of messing around with it, I found a Solution!

So you have to have two rules.

First one is Cell is Empty, set the background color to white (not sure why this is needed, but it is crucial for it to work)

Second rule is Custom Formula is =len(B2)>150, set background color to red (this will set it to red if the their is over 150 characters.

This test spreadsheet really helped me out. (gotta make a copy to mess with it)
https://docs.google.com/spreadsheets/d/1ScDqtZvhsmf2iByAuxHBu0-ESpX_TE5pdtBvAxOJ99E/edit#gid=1620525099

Your welcome,
Chris

U7rW8SV