Sub test2()
Dim rng As Range
Dim fc As FormatCondition
Sheets(1).Select
Cells.FormatConditions.Delete
Set rng = Range("a1").CurrentRegion
Range("a2").Activate
Set fc = rng.FormatConditions.Add(Type:=xlExpression, Formula1:="=countblank($e2:$f2)=1")
fc.Interior.ColorIndex = 6
End Sub
Sub test()
Dim rng As Range
Dim fc As FormatCondition
Sheets(1).Select
Cells.FormatConditions.Delete
Set rng = Range("a1").CurrentRegion
Set fc = rng.FormatConditions.Add(Type:=xlExpression, Formula1:="=countblank($e2:$f2)=1")
fc.Interior.ColorIndex = 6
End Sub
Sub test2()
Dim rng As Range
Dim fc As FormatCondition
Sheets(1).Select
Cells.FormatConditions.Delete
Set rng = Range("a1").CurrentRegion.Offset(1, 0)
Set fc = rng.FormatConditions.Add(Type:=xlExpression, Formula1:="=countblank($e2:$f2)=1")
fc.Interior.ColorIndex = 6
End Sub