Saturday, November 24, 2012

yogi_WorkAround To Apply Conditional Formatting For Condition 'Cell Is Not Empty'


                                          Google Spreadsheet   Post  #888
              Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Nov 24, 2012
user Clown Guy said:(http://productforums.google.com/forum/?zx=jnm1y5sz2w47#!category-topic/docs/spreadsheets/l7Gq8mloYR4)
Feature Request For Google Sheets - Conditional Formatting - 'Cell Is Not Empty'
Hi,

An almost embarrassingly simple but important feature request.

There is currently a conditional formatting option for 'Cell is empty' but not an option for 'Cell is not empty' or 'Cell contains data'.

There is an option for 'Cell contains' and its opposite 'Cell does not contain'. There is an option for 'Cell is empty' but not its opposite.

This is a very simple but powerful feature that allows any cell with any data in it to be formatted in some way.

Is this the right place to post this feature request and if not, can someone help by posting a link to where I can propose this feature request?

Thanks

Clown Guy
-----------------------------------------------------------------------------------------------------
following is a simple WorkAround solution to the problem