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,
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.
Posted by Aladin Akyurek on February 11, 2002 12:36 PM
Choose "Formula Is" and enter as formula:
=LEN(E5)=0
==================
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, "").
==========
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?
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
===============
