I want to do conditional formatting on my spreadsheet. My labels are on row 7, columns A:E. I want my conditional formatting to start with row 8. It applies the formatting to row 8 but changes the formula to row 9. I don't understand.
The formatting that is cell A8 is:
"=IF(AND($E9="Voided",$D9>0),TRUE,FALSE)"
All help is GREATLY appreciated
Code:
Private Sub ConditionalFormattingForRefundCkReg()
Selection.FormatConditions.Delete
Range("A8").CurrentRegion.Select
Selection.FormatConditions.Add Type:=xlExpression, Formula1:= _
"=IF(AND($E8=""Voided"",$D8>0),TRUE,FALSE)"
Selection.FormatConditions(1).Interior.ColorIndex = 38
End Sub
The formatting that is cell A8 is:
"=IF(AND($E9="Voided",$D9>0),TRUE,FALSE)"
All help is GREATLY appreciated