ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Hide cell based on value of another cell (https://www.excelbanter.com/excel-worksheet-functions/159152-hide-cell-based-value-another-cell.html)

audreyg

Hide cell based on value of another cell
 
Is there a function or something I can use to hide a cell based on the value
of another cell?

For example, I want to hide the information in cell B5 if cell A5 doesn't
have any information in it

JNW

Hide cell based on value of another cell
 
I usually just use conditional formatting and make the font color make the
cell color to make the info "disappear."
--
JNW


"audreyg" wrote:

Is there a function or something I can use to hide a cell based on the value
of another cell?

For example, I want to hide the information in cell B5 if cell A5 doesn't
have any information in it



All times are GMT +1. The time now is 11:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com