Clear all cells when the are not between 0.90-0.95

formulas can't clear cells, you could write a formula in another area that would indicate which cells to clear or a formula that returns a blank if the cell is not between those parameters and the numbers that are within those parameters, then copy over those values and paste them into the same cells. Is that something you can work with? otherwise you will need VBA.

this would be the formula version... =IF(OR(C3<0.9,C3>0.95),"",C3) then copy and paste special the results over the column C, repeat for E, G and I.

pls try this code

Please Login or Register  to view this content.

well I did not write the code so the credit goes to wk9128 but I would assume you'd make the change here...

PHP Code: 

Sub wkClearCells()
    Application.ScreenUpdating = False
    Application.Calculation = xlCalculationManual
    Dim ws As Worksheet
    Dim rng As Range
    Dim cell As Range
    Dim cellsToClear As Range
    Set ws = ThisWorkbook.Worksheets("Blad1")
    Set rng = ws.Range("C3:C11,E3:E11,F3:F11,I3:I11")
    For Each cell In rng
        If Not (cell.Value >= 0.9 And cell.Value <= 0.95) Then
            If cellsToClear Is Nothing Then
                Set cellsToClear = cell
            Else
                Set cellsToClear = Union(cellsToClear, cell)
            End If
        End If
    Next cell
    If Not cellsToClear Is Nothing Then
        cellsToClear.ClearContents
    End If
    Application.ScreenUpdating = True
    Application.Calculation = xlCalculationAutomatic
End Sub 


note to admin/moderators, I tried to use html settings but it wouldn't show properly - sorry.

Or this. You can adjust columns in the red line:

Please Login or Register  to view this content.