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 MI    Feb 11, 2013
user Light_Speed said:(!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.
following is a WorkAround Solution