View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
intruder9
 
Posts: n/a
Default Hide cell value conditional on its value


In this instance lets say the sheet with the salary figures is named
January, on another sheet you could use the following formula to
reference the information =IF(January!B150,"x","") this will put
an x in place if the cell is above 0 or a blank if the cell is empty.


--
intruder9
------------------------------------------------------------------------
intruder9's Profile: http://www.excelforum.com/member.php...o&userid=30107
View this thread: http://www.excelforum.com/showthread...hreadid=497997