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
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.
ReplyDeleteHi kcurtis:
ReplyDeleteGreat ... 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