View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Junior[_2_] Junior[_2_] is offline
external usenet poster
 
Posts: 11
Default Conditional formatting formula

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?