hiden list number formula

[iraidotel]

Hi,

I have a list, and I want to remove temporary,
if in a box filter on the input numbers, then the numbers in the list is missing, how his formula

please help yes

thank you

regards Ira

 

[Somendra Misra]

Hi Ira,

Once again the explanation does not make sense (at least to me).

Care to explain in more depth.

Regards,

 

[Hui]

As with Somendra, it is a bit unclear exactly what you want

You could use Conditional Formatting to change the display colors of the List so it appears to not be there based on some criteria

Or

You could put the list over to the side and then only retrieve it using a formula based on the criteria

A better explanation will assist us assist you.
Remember that you know what you want to achieve, we don't

 

[iraidotel]

As with Somendra, it is a bit unclear exactly what you want

You could use Conditional Formatting to change the display colors of the List so it appears to not be there based on some criteria

Or

You could put the list over to the side and then only retrieve it using a formula based on the criteria

A better explanation will assist us assist you.
Remember that you know what you want to achieve, we don't

Her response thanks
how to optin first to use Conditional Formatting and I do not know how, maybe you can help me

so that the list does not appear when we enter three numbers on the filter.

thus

regards, Ira

 

[Hui]

Ira
Select the list D5:E88
Conditional Formatting
New Rule
Use a Formula
=COUNT($B$5:$B$7,">"&0)
Set the Font to White
Apply

see attached file:

 

[iraidotel]

Ira
Select the list D5:E88
Conditional Formatting
New Rule
Use a Formula
=COUNT($B$5:$B$7,">"&0)
Set the Font to White
Apply

see attached file:

Hui, perfect, thank you very much

regards, Ira