Archive of Mr Excel Message Board

Back to Forms in Excel VBA archive index
Back to archive home

Conditional Formatiing

Posted by Zac on February 11, 2002 12:28 PM

Is there a way of using Conditional Formating to
turn a cell to a color if the cell is "empty"?
Ican do it using a "blank (space bar", but I don't
want to do it that way.

Thanks,

Re: Conditional Formatiing

Posted by Chris Y on February 11, 2002 12:34 PM

In Conditional Formatting, you could try the "If Formula is" to "=ISBLANK(CellRef)", then set your fomatting.

Re: Conditional Formatiing

Posted by Aladin Akyurek on February 11, 2002 12:36 PM

Choose "Formula Is" and enter as formula:

=LEN(E5)=0

==================

Re: Conditional Formatiing

Posted by Aladin Akyurek on February 11, 2002 12:39 PM

ISBLANK will not work wrt a cell containing a formula returned blank (that is, "").

==========

Re: Conditional Formatiing

Posted by ZAC on February 11, 2002 12:53 PM

* * * * *

I would prefer to set the Formatting using Value rather than Formula because the other 300+ cells are set up that way. I tried using equal to "", but that didn't work like I expected. Any other ideas?

Re: Conditional Formatiing

Posted by Aladin Akyurek on February 11, 2002 1:01 PM

> I would prefer to set the Formatting using Value rather than Formula because the other 300+ cells are set up that way. I tried using equal to "", but that didn't work like I expected. Any other ideas?

ZAC,

I understand the preference for consistency. But, if you have no choice?

Aladin

===============

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.