Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: poison1701
- Order by date
-
Excel - Hide Red Rows
Definitely not, however, in order to make it flexible for the end user, this will work just fine, and it runs fast.- poison1701
- Post #10
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Excel - Hide Red Rows
Here is a link to the answer I was seeking. Thanks to all who helped. http://www.cpearson.com/excel/CFColors.htm- poison1701
- Post #8
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Excel - Hide Red Rows
I am preferring to test if conditional formatting is applied, so that the end user of the spreadsheet can easily make changes to the format and still end up with the same result. How can I test if conditional formatting is applied to a cell? *Note I dont know if it matters but we are using Excel...- poison1701
- Post #6
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Excel - Hide Red Rows
The color will be set by conditional formatting. What can I do in this case?- poison1701
- Post #4
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Excel - Hide Red Rows
I would like to have a toggle button on a spreadsheet that is able to hide/unhide a row if any cell in that row has a background color of red. Using code I have found, I came up with the following, but it will only hide a row if it's empty. Sub HideRedRows(Mode As Boolean) Dim r As Range Dim...- poison1701
- Thread
- Replies: 10
- Forum: VBA Visual Basic for Applications (Microsoft)
