Saturday, July 2, 2011

yogi_Apply Conditional Formatting To A Data Validated List

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                  
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