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.
Tuesday, January 20, 2015
yogi_Conditionally Format Cell J6 Background Red If only J5 is checked (=x) Yellow if only K5 is checked Green if only L5 is checked
post by Chaos234: https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/__lrhlfqKZE Why is Google Sheets so tupied to parse formula correctly?
Actually I'm very angry about GS!
All what I want is a simple color fomarted cell over a formula!
Conditonal formating is not useable because there is one missin field! It has to have a condition field, a field from how the data in the condition is to catch/to check and a field which zell is affected by the result of the condition and that isn't possible yet!
So I tried the following:
=IF(J5="x",ROWS(G6:G8)=TEXT(F5, "#ff0000"),"") but all I get is a Circular dependency detected and that can't also be possible!
What I want to do?
I want to change the text color red in the affected zell, if J5 is checked (value = x). But if K5 is checked, then the text color should be yellow and if L5 is checked, it should be green.
For what is the Sheet?
This sheet contains a development tree with some conditions. If you want to use rockets, you may have to develop fuel first so the sheet must also check, if the prerequired development is
Is there a macro or a GS-Code sniped for that to sol this?
Also it will be fine if you can only check one from three from J5 to L5 and not more.
Hope that I can get some help to solve this problem.