PPRuNe Forums - View Single Post - MS Excel Query
Thread: MS Excel Query
View Single Post
Old 11th May 2004 | 11:02
  #2 (permalink)  
ck4707
 
Joined: Dec 2002
Posts: 66
Likes: 0
From: wirral
Yes.

Assuming you only want the cell to show a number when it is not zero highlight the cell click on format then conditional formatting.
enter in the boxes cell value is equal to 0

then click on format select white as the colour (assuming you are leaving the cell white!) then ok ok

Hope this helps

CK
ck4707 is offline