How about the ISBLANK function?

=ISBLANK(A1)=FALSE

HTH,
Elkar


"Paperback Writer" wrote:

What if they key in "0" for the value? That is a real possibility.

"jjones" wrote:

Can't you just set your condition like this?

Cell Value Is -- equal to -- 0

"Paperback Writer" wrote:

I am using conditional formatting in regards to a form that needs to be
filled out. As the user fills out the required fields, the fields change
from YELLOW to WHITE.

Trouble I am having is alpha-numerics. I need an "IS" statement that allows
me to change the cell from YELLOW to WHITE whenever ANY VALUE is placed into
the particular cell.

I need something like: =ISANYVALUE(A1)

THANK YOU