Using the following conditional format formula in a cell to display as gray
when the cell is blank .=$A$1=""
this works, as long as the delete button is used to clear the
cell.

what should my formula look like to display as gray if the user pressed the
space bar instead of the delete key to clear the cell?

"Junior" wrote in message
...
Using the following conditional format formula in a cell to display as
gray
when the cell is blank .=$A$1=""
this works, as long as the delete button is used to clear the
cell.

what should my formula look like to display as gray if the user pressed
the
space bar instead of the delete key to clear the cell?

Hi Junior,

Here's one way to do it:

=LEN(TRIM($A$1))=0

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *

Super- that worked great
thanks
"Rob Bovey" wrote in message
...
"Junior" wrote in message
...
Using the following conditional format formula in a cell to display as
gray
when the cell is blank .=$A$1=""
this works, as long as the delete button is used to clear the
cell.

what should my formula look like to display as gray if the user pressed
the
space bar instead of the delete key to clear the cell?

Hi Junior,

Here's one way to do it:

=LEN(TRIM($A$1))=0

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *