View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
al al is offline
external usenet poster
 
Posts: 363
Default Difference of empty cell and zero value when formatting

I'd like to conditionally format a cell if the value zero is entered into it,
however to leave the cell without formatting if the cell if empty. My
attempts at doing so using something like formula is =q54=0 format the cell
regardless of whether the cell has a zero or is empty!

Appreciate any help...thanks!