Conditional formatting formula

[Junior]

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?

 

[Rob Bovey]

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 *

 

[Junior]

Super- that worked great
thanks

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 *