View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JNW JNW is offline
external usenet poster
 
Posts: 480
Default Hide cell based on value of another cell

I usually just use conditional formatting and make the font color make the
cell color to make the info "disappear."
--
JNW


"audreyg" wrote:

Is there a function or something I can use to hide a cell based on the value
of another cell?

For example, I want to hide the information in cell B5 if cell A5 doesn't
have any information in it