Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Hide/Unhide Cells
I am trying to use a formula in excel to unhide a row if a cell elsewhere in the worksheet has a value of "No." So far I have found only macros to do this, but I am not extremely versed in Macros, can anyone assist?
I will need to use this on multiple lines throughout the workbook. And if the only way to do this is with a macro, can someone please explain it in the most layman's terms possible? Thank you, Eddy |
#2
|
|||
|
|||
Quote:
To do this: - Highlight the cells you want to "hide" and select Conditional Formatting (on the Home button bar in Excel 7, under the Format menu in older versions from memory). - Add a conditional Formatting rule - Use the "Use formula to determine which cells to format" option - type in the formula: =IF($B$3="No",TRUE,FALSE) - Format the Font colour to White NB: The "TRUE" and "FALSE" values work equally as well as 1 and 0, however written this way it is easier to understand what it is doing. NB2: I used Cell B3 as an example of where your "No" value will appear, and the $ mean that it is in a fixed location. Remove the $ if you want to use a range of cells containing the "No" value. Now when the value of B3 changes to No, the cells you applied Conditional Formatting to will become white. If you really need to hide the column, let me know and I can try to explain the macro required. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hide/Unhide row VBA | Excel Discussion (Misc queries) | |||
Hide and unhide shaded cells | New Users to Excel | |||
hide/unhide | Excel Discussion (Misc queries) | |||
Switching views - Hide / Unhide preselected cells (Repost) | Excel Discussion (Misc queries) | |||
hide/unhide cells | Excel Worksheet Functions |