Yogi Anand, D.Eng, P.E. Google Spreadsheet www.energyefficientbuild.com
TheLuanM said:Conditional formatting does not updating automatically
--------------------------------------------------------------
In Google spreadsheet as of this time Conditional Formatting can not be based on comparison with values in another cell.
Conditional Formatting can however be applied to a range where Data Validation has been used and the colors will automatically get updated when a different value is used in the range whaere Data Validation has been applied ... fo rxample see the following illustration in my Blog on Cloud Computing -- Google Docs Way
