I want to be able to hide a selection of cells, including the border formatting, when another cell has a particular value (in this case I want the cells visible only if the value in the cell is above 0). I've looked around and can't seem to find anything relevant. Anyone got any ideas?
Cheers.
Last edited by shockerty; 05-07-2009 at 08:51 PM. Reason: [SOLVED]
Hi shockerty,
One approach is to select the cells you want hidden, remove all regular formatting, then change the font colour to white.
Now select "Format --> Conditional Formatting" (or whatever the path is for Excel 2007 to Conditional Formatting), and select Formula is: and use =$A$1>0 where A1 is the cell with your "particular value". Now set the conditional formatting to make the font colour automatic and the borders as you prefer. Click Okay.
Cheers,
“To sin by silence when they should protest makes cowards of men.” ~ Abraham Lincoln
Re: Hiding cells when the value of a cell is a certain number
Ah yeah. Didn't think of that! Ha. Thanks very much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks