yogi_Create A Computed Column For Weight Loss In Column F For Successive Weekly Entries In Column E

                                          Google Spreadsheet   Post  #1270
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jul 03, 2013
user Paul Deans (http://productforums.google.com/forum/?zx=en1uc39g9p3s#!category-topic/docs/spreadsheets/AUs2BaP79XI)
Weight Tracker Help and Ideas
Hi All,

Trying to put together a Weight Tracker "sheet" that will show progress as the weeks go by so weight and inches loss can be tracked weekly.

• I want the spreadsheet to utilise Green for weight loss and Red for weight gain as background colour and this would show on the sheet automatically upon data entry in column "C" and "D". This would be reflected on the weight and inches measurement from the week previous any ideas on how to get a formula to successfully do this?

I have shared the doc below and comments can be left.

Weight Tracker

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