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 MI     www.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?

Example

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.

-------------------------------------------------------------------------------------------------------

following is a WorkAround Solution