|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 20th, 2009, 05:01 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Way to hide rows when a cell contains numbers less than a value?
|
|
#2
May 20th, 2009, 05:10 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Way to hide rows when a cell contains numbers less than a value?
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.
|
|
#3
May 20th, 2009, 05:19 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Way to hide rows when a cell contains numbers less than a valu
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. "Glenn" wrote: 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.
|
|
#4
May 20th, 2009, 08:08 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Way to hide rows when a cell contains numbers less than a valu
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. lcExcelUser wrote: 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. "Glenn" wrote: 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.
|
|
#5
May 20th, 2009, 11:41 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Way to hide rows when a cell contains numbers less than a value?
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 On Wed, 20 May 2009 09:01:01 -0700, lcExcelUser wrote:
|
|
#6
May 20th, 2009, 11:43 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Way to hide rows when a cell contains numbers less than a valu
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 On Wed, 20 May 2009 09:19:01 -0700, lcExcelUser wrote: 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. "Glenn" wrote: 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.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
