Conditional formating (null) cell?

  • Thread starter Thread starter Cassini
  • Start date Start date
C

Cassini

Hi,
Is it possible to format a blank(null) cell so that it shows the text
"Not valid!" in red, when no value has been entered.
//Cassini
 
Format the cell to be filled in red if it is blank (I don't know how to
get the text to appear without a lot of ugly programming). Either of
these formulas set it off:

=ISBLANK(A1)
=LEN(A1)=0

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Thanks Jon for the suggestion.
I guess it's hard to make Excel do a calculation when the cell i
blank.

However, while I was at it, I found a odd thing.

Try this:
1. Select Conditional Formating.
2. Cell Value Is equal to =CELL("prefix")
and format the pattern to orange

Now enter a Number, anywhere in the sheet....nothing, right!
Now enter a Letter, anywhere in the sheet....orange disappears.
Now, delete the number you just typed....and the orange is back!

I don't know when this could be useful, but it could be fun to hea
some suggestions.
//Cassin
 
Back
Top