Hi,
I've managed to conditionally format a cell with VBA (im a vba noobie)
What I really want to do is format a range of rows.
Currently criteria from Column I and I want to color rows E to J.. I’m just not sure how to select the row. Is it Range.Select(), or Cell.Select() ?

I've commented my poor attempt in the code to select the appropriate rows.
Private Sub Worksheet_Calculate()
    Dim icolor As Integer
    For Each r In Range("I10:I30")
            With r
                Select Case .Value
                    Case 0 To 0.69
                       'cells("E:J")
                        icolor = 10  'green
                    
                    Case 0.7 To 0.89
                        icolor = 44  'amber
                        'Range.Select ("E:J")
Cheers
Cam