Thread: Hidding zero values
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Steve J Steve J is offline
external usenet poster
  
Posts: 7
Default Hidding zero values
RadarEye wrote in news:573e1ff3-2559-4ceb-88c1-
:

On 7 dec, 15:45, Steve J wrote:
Hi all,

I know how to hide all zero values in 2003, but the problem is *only
wa
nt
to hide zero values of selected rows. Is there anyway to do this?

Hi Steve,

Try your luck with conditional format.
As conditoon use value= zero
As format make the font color the same as the interiour color.

HTH,

Radareye.


Tried both and work great! thx guys

Reply With QuoteReply With Quote