Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how to create a formula to hide specific rows after meeting requi
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how to create a formula to hide specific rows after meeting requi
A formula cannot change the appearance of a cell
You could use Format |Conditional Formatting to give the cells in the row a font colour the same as the background so as to be invisible. best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "DNelson" wrote in message ... |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how to create a formula to hide specific rows after meeting requi
Hi D.,
or a filter to hide the rows, and the formulas work the same as for Conditional Formatting the object is to produce True or False (or the equivalent). Some information on Filters: http://www.datapigtechnologies.com/ExcelMain.htm flash presentations http://www.contextures.com/tiptech.html look for fitler Please post a real question in the text body, as you can probably see the text of your subject was truncated which makes question even more ambiguous. Leaving the text body empty is confusing and more frequently than not results in very ambiguous questions by those who won't take the time to ask a proper question. For instance if you already know about filters that is not conveyed. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Bernard Liengme" wrote in message ... A formula cannot change the appearance of a cell You could use Format |Conditional Formatting to give the cells in the row a font colour the same as the background so as to be invisible. best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "DNelson" wrote in message ... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert rows based on specific value | Excel Worksheet Functions | |||
Help - Need Formula To Hide Rows | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
How to create specific formula | Excel Worksheet Functions |