I am trying to write a VBA code that can manage a spreadsheet. It's a relatively simple code but I seem to be having an issue with it. I need the code to be able to do some conditional formatting for cells (9-53) in columns C,D,E. The conditional formatting should change the font color of the cell to red if it's outside my limits and the font color should be green if it's inside my limits. However, the limits for cells in column C are different from the limits in column D which are different from the limits in column E. For example:

The acceptance criteria for column C is -.02<= cell.Value <= 0.02
The acceptance criteria for column D is -3 <= cell.Value <= 3
The acceptance criteria for column E is 0 <= cell.Value <= .04

I also have some code that manipulates the worksheet to hide rows that aren't needed based on a selection made from a dropdown list in cell C4.

Sub Worksheet_Change(ByVal Target As Range)
Rows("2:53").EntireRow.Hidden = False
If Range("C4").Value = "XOL" Then
Rows("42:53").EntireRow.Hidden = True

ElseIf Range("C4").Value = "ES" Then
Rows("46:53").EntireRow.Hidden = True


ElseIf Range("C4").Value = "FS" Then
Rows("29:53").EntireRow.Hidden = True

ElseIf Range("C4").Value = "HL" Then
Rows("2:53").EntireRow.Hidden = False

End If

End Sub

Can someone help me figure out some code that could be included in the above code that does the formatting? I can do it with a single column but I seem to be having trouble getting multiple columns to work.

Thanks.