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


2 comments:

  1. Another alternative is to apply conditional formatting for what cell should look like when it is empty. Then apply a second format for when cell does not contain a specific combination of highly unused characters such as "†®µ∑". That way when it is empty it is empty and when it is not empty it will most likely not match and thus format correctly.

    ReplyDelete
  2. Hi kcurtis:

    Great ... Thanks For Your Contribution ... Now Let us Keep Googling.

    Make It A Great One
    Cheers!
    Yogi
    Cloud Computing -- Google Docs Way
    yogi--anand-consulting.blogspot.com

    ReplyDelete