| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hide Cell based on value of other cell
Is there a way that you can hide the value of a cell depending on the value
of the cell directly in front of it? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Hide Cell based on value of other cell
If we want to hide D5 if C5 has the value 1, use conditional formatting on D5
to Formula Is: =C5=1 and pick the font color to match the background color. -- Gary''s Student - gsnu200746 "audreyg" wrote: Is there a way that you can hide the value of a cell depending on the value of the cell directly in front of it? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Hide Cell based on value of other cell
How do I do it if I want the condition of C5 to be "Blank" instead of a
number value? "Gary''s Student" wrote: If we want to hide D5 if C5 has the value 1, use conditional formatting on D5 to Formula Is: =C5=1 and pick the font color to match the background color. -- Gary''s Student - gsnu200746 "audreyg" wrote: Is there a way that you can hide the value of a cell depending on the value of the cell directly in front of it? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Hide Cell based on value of other cell
What is currently in C5?
If a formula you could enter in C5 something akin to =IF(ISNUMBER(B5),"",B5) Gord Dibben MS Excel MVP On Thu, 20 Sep 2007 11:54:02 -0700, audreyg wrote: How do I do it if I want the condition of C5 to be "Blank" instead of a number value? "Gary''s Student" wrote: If we want to hide D5 if C5 has the value 1, use conditional formatting on D5 to Formula Is: =C5=1 and pick the font color to match the background color. -- Gary''s Student - gsnu200746 "audreyg" wrote: Is there a way that you can hide the value of a cell depending on the value of the cell directly in front of it? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hide sheets based on Cell value | Excel Discussion (Misc queries) | |||
| Hide cell values based on a condition in another cell | Excel Worksheet Functions | |||
| hide rows based on cell value | New Users to Excel | |||
| hide rows based on value in cell | Excel Discussion (Misc queries) | |||
| Is there a way to HIDE a row based on a value of a cell ? | Excel Discussion (Misc queries) | |||
Linear Mode
