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.
Monday, February 11, 2013
yogi_WorkAround For Conditional Formatting A Cell Based On Value in Another Cell
Google Spreadsheet Post #1025
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MIwww.energyefficientbuild.com. Feb 11, 2013 user Light_Speed said:(http://productforums.google.com/forum/?zx=m0hxh0wcck9h#!category-topic/docs/spreadsheets/Lw3MN-5wlTQ) Complex Conditional Formatting
In a GSheet I am looking for a way to format data in column d based on data in same row in column c.
Is this possible?
c10 = 100
d10 = 135
d10 is greater than c10
c22 = 400
d22 = 15
d22 is less than c22
I would like d10 data to be green
I would like d22 data to be red
Can I do this with conditional formatting on the whole column or is there another way or any way?
I am able to do this in Open Office Calc but can't get it to work in a GSheet.