yogi_Conditionally Format Cells If The Value In The Cell Is Less Than The Value In The Cell Above It

                                         Google Spreadsheet   Post  #1603
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Apr-14-2014
post by WaffullTechSystems (https://productforums.google.com/forum/#!mydiscussions/docs/vPFxhYPVHko)
conditionally format based on a % value in different cell.

I have columns of data an

d I want to conditionally format the cells so that if the cell is less than (all data are percentages, %,) the cell above it, the font is set to white and background to red.

I tried a few things that I saw in the forums, but couldn't get it to work.

This is for a spreadsheet on the New Sheets. 

Thanks for the help.

Marc

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