L
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Way to hide rows when a cell contains numbers less than a value?
G
Glenn
lcExcelUser wrote: NOTHING!
Try filter in the help file. If that doesn't help, try posting a question and
some details in the body of your message.
Try filter in the help file. If that doesn't help, try posting a question and
some details in the body of your message.
G
Glenn
lcExcelUser wrote: NOTHING!
Try filter in the help file. If that doesn't help, try posting a question and
some details in the body of your message.
Try filter in the help file. If that doesn't help, try posting a question and
some details in the body of your message.
L
lcExcelUser
have a worksheet where it contains data. I have actual numbers in one
column, budgeted numbers in the second, and variances in the third (the
difference between the two). Is there any way for worksheet to automatically
hide numbers of less than a value (let's say $5,000).
I know how to highlight, but i didn't know if there is a way to do without
manually highlighting.
column, budgeted numbers in the second, and variances in the third (the
difference between the two). Is there any way for worksheet to automatically
hide numbers of less than a value (let's say $5,000).
I know how to highlight, but i didn't know if there is a way to do without
manually highlighting.
L
lcExcelUser
have a worksheet where it contains data. I have actual numbers in one
column, budgeted numbers in the second, and variances in the third (the
difference between the two). Is there any way for worksheet to automatically
hide numbers of less than a value (let's say $5,000).
I know how to highlight, but i didn't know if there is a way to do without
manually highlighting.
column, budgeted numbers in the second, and variances in the third (the
difference between the two). Is there any way for worksheet to automatically
hide numbers of less than a value (let's say $5,000).
I know how to highlight, but i didn't know if there is a way to do without
manually highlighting.
G
Glenn
Did you look at the help file? Maybe this will help:
http://www.contextures.com/xlautofilter01.html
If you are NOT trying to hide the rows where the value in a certain column
(variance?) is less than a specified value ($5,000), then try explaining again.
http://www.contextures.com/xlautofilter01.html
If you are NOT trying to hide the rows where the value in a certain column
(variance?) is less than a specified value ($5,000), then try explaining again.
G
Glenn
Did you look at the help file? Maybe this will help:
http://www.contextures.com/xlautofilter01.html
If you are NOT trying to hide the rows where the value in a certain column
(variance?) is less than a specified value ($5,000), then try explaining again.
http://www.contextures.com/xlautofilter01.html
If you are NOT trying to hide the rows where the value in a certain column
(variance?) is less than a specified value ($5,000), then try explaining again.
G
Gord Dibben
Event code.
Private Sub Worksheet_Calculate()
If cell.Value < 123 Then
Rows(somerows).EntireRow.Hidden = True
End Sub
If you used the large white space to describe your needs we can probably
tailor a solution to those needs.
Gord Dibben MS Excel MVP
Private Sub Worksheet_Calculate()
If cell.Value < 123 Then
Rows(somerows).EntireRow.Hidden = True
End Sub
If you used the large white space to describe your needs we can probably
tailor a solution to those needs.
Gord Dibben MS Excel MVP
G
Gord Dibben
Event code.
Private Sub Worksheet_Calculate()
If cell.Value < 123 Then
Rows(somerows).EntireRow.Hidden = True
End Sub
If you used the large white space to describe your needs we can probably
tailor a solution to those needs.
Gord Dibben MS Excel MVP
Private Sub Worksheet_Calculate()
If cell.Value < 123 Then
Rows(somerows).EntireRow.Hidden = True
End Sub
If you used the large white space to describe your needs we can probably
tailor a solution to those needs.
Gord Dibben MS Excel MVP
G
Gord Dibben
Try Conditional Formatting to color the font same as background.
Elsewise you would need some code because formulas cannot hide things.
Gord Dibben MS Excel MVP
Elsewise you would need some code because formulas cannot hide things.
Gord Dibben MS Excel MVP
G
Gord Dibben
Try Conditional Formatting to color the font same as background.
Elsewise you would need some code because formulas cannot hide things.
Gord Dibben MS Excel MVP
Elsewise you would need some code because formulas cannot hide things.
Gord Dibben MS Excel MVP