yogi_Workaround For Applying Conditional Formatting When Cell Values Needs To Be Compared With Values Of Successive Following Cells

                                          Google Spreadsheet   Post  #1377
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Sep 23, 2013

user  Scott DK (http://productforums.google.com/forum/?zx=uyr15nwjbsi3#!searchin/docs/Scott$2C$20DK%7Csort:relevance/docs/sDlsUhAywNw/bcOcebkszM8J)
Can you do IF THEN formulas in Google spreadsheets?
I'm trying to compare cell A1 with cell A2.  If A1 is greater it turns red.  If A2 is greater it turns green.  Is this function possible in Google Docs?
--------------------------------------------------------------------------------------------------------------------------------------------------