View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
penri0_0
 
Posts: n/a
Default make cell show blank when total is zero


Go to Format on the tool bar, select conditional formatting. Select cell
value is 'equal to' and then type 0 in the next box. Then select the
format box and seT the text colour to white. Then if your formula
returns 0 the cell will appear blank.


--
penri0_0


------------------------------------------------------------------------
penri0_0's Profile: http://www.excelforum.com/member.php...o&userid=28947
View this thread: http://www.excelforum.com/showthread...hreadid=543743