| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Value in one cell visible of another cell has anything in it
I used to know how to do this, and can't remember. I think it is a COUNTIF
function in the first cell, together with conditional formatting in the 2nd cell, but I can't remember how to set it up. cell A1: any text at all entered will cause cell A2: part number to be visible. cell A1: empty value in cell A2 remains hidden. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Value in one cell visible of another cell has anything in it
I am postng this in the Formula section where it belongs - sorry about that
"Jules" wrote: I used to know how to do this, and can't remember. I think it is a COUNTIF function in the first cell, together with conditional formatting in the 2nd cell, but I can't remember how to set it up. cell A1: any text at all entered will cause cell A2: part number to be visible. cell A1: empty value in cell A2 remains hidden. |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Value in one cell visible of another cell has anything in it
Select A2 and FormatCFFormula is: =ISBLANK(A1)
Format to white font. Gord Dibben MS Excel MVP On Wed, 6 Feb 2008 17:10:00 -0800, Jules wrote: I used to know how to do this, and can't remember. I think it is a COUNTIF function in the first cell, together with conditional formatting in the 2nd cell, but I can't remember how to set it up. cell A1: any text at all entered will cause cell A2: part number to be visible. cell A1: empty value in cell A2 remains hidden. |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Value in one cell visible if another cell has anything in it
Thanks Gord. If I could have edited this post or deleted it I would have, I
put it in the wrong place. Thanks for the quick response! "Gord Dibben" wrote: Select A2 and FormatCFFormula is: =ISBLANK(A1) Format to white font. Gord Dibben MS Excel MVP On Wed, 6 Feb 2008 17:10:00 -0800, Jules wrote: I used to know how to do this, and can't remember. I think it is a COUNTIF function in the first cell, together with conditional formatting in the 2nd cell, but I can't remember how to set it up. cell A1: any text at all entered will cause cell A2: part number to be visible. cell A1: empty value in cell A2 remains hidden. |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Value in one cell visible if another cell has anything in it
Why do you consider this news group as "the wrong place"?
Gord On Wed, 6 Feb 2008 18:11:00 -0800, Jules wrote: Thanks Gord. If I could have edited this post or deleted it I would have, I put it in the wrong place. Thanks for the quick response! "Gord Dibben" wrote: Select A2 and FormatCFFormula is: =ISBLANK(A1) Format to white font. Gord Dibben MS Excel MVP On Wed, 6 Feb 2008 17:10:00 -0800, Jules wrote: I used to know how to do this, and can't remember. I think it is a COUNTIF function in the first cell, together with conditional formatting in the 2nd cell, but I can't remember how to set it up. cell A1: any text at all entered will cause cell A2: part number to be visible. cell A1: empty value in cell A2 remains hidden. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I cross out something in a cell to keep it visible | Excel Worksheet Functions | |||
| Visible text in a cell | New Users to Excel | |||
| how can i do a (fx) visible in a cell | Excel Worksheet Functions | |||
| Cell selection not visible | Excel Discussion (Misc queries) | |||
| Visible cell characters | Excel Discussion (Misc queries) | |||
Hybrid Mode
