Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hide cell unless value entered into any cell on a row
Hi guys -
I have a worksheet that contains a summary of data that is entered in a different part of the same worksheet (i.e. Page 1 in the worksheet is the printable report). I want to hide a title in the summary section (lets say this is cell A1) unless data is filled into any cell in a specified row (J14:T14). Using the IF principle I thought I could use =IF(J14:T14,I14,"") - where J14:T14 is the row where data is entered and I14 is the text that I want displayed in A1 should there be data entered in this row. comes up with #VALUE! Any ideas where I am going wrong or if this is actually possible? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
unlock cell dependent on value entered in another cell | Excel Discussion (Misc queries) | |||
Change color of cell when different cell has data entered | Excel Discussion (Misc queries) | |||
auto-hide rows, cell format (# and @), update cell refs, shade cel | Excel Discussion (Misc queries) | |||
Hide cell values based on a condition in another cell | Excel Worksheet Functions | |||
Rows to drop off (hide) when a value is entered into a cell | Excel Discussion (Misc queries) |