IF statement or cond'tl format to show sparklines

[richardcarter]

I have a worksheet with 3,000 rows.. and each row has a sparkline... as such, it takes up quite a bit of processing power (and a few seconds) to display them all after I make any changes to the formula which they are based on.

To make my life easier and speed things up a bit, I was wondering if anyone had come across any method to show only those sparklines which meet a certain condition... because I dont need to see all of them unless they meet a certain criteria.


I am thinking along the lines of "IF CELL A10 > CELL A11", then show the sparkline, otherwise don't show it.

Alternatively... a conditional format that would effectively do the same thing?

 

[cyrilbrd]

You could add a Helper Column in the location of your choice with a formula such as:

=IF(A10>A11,"","HIDE")

Then add this code:

Sub Hide()

    Application.ScreenUpdating = False
     ' richardcarter set here the range of the helper column per example"AA1:AA3000"
    With ActiveSheet
        For Each cell In Range("AA1:AA3000")
            If cell.Value = "HIDE" Then
                cell.EntireRow.Hidden = _
                Not cell.EntireRow.Hidden
            End If
        Next
    End With
    Application.ScreenUpdating = True

End Sub

You can modify the code to fit your needs.
Would this work for you?