Saturday, July 2, 2011

yogi_Apply Conditional Formatting To A Data Validated List

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