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

             Google Spreadsheet   Post  #1883
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jan-20-2015
post by  Chaos234:
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.