Thanks Brian, I am actually making headway. As with most projects, one solution can lead to another issue. How can I automate the conditional formatting to work for each individual cell in a range? i.e. If I the Sub would be:
Range ("A3:B4").Copy Range ("A10")
End Sub
How can if conditionally format A3:B4 to coincide with A10:B11 without having to format each cell individually?
So far I have:
Sub Conditional()
Range("A3:B4").Select
Selection.FormatConditions.Delete
Selection.FormatConditions.Add Type:=xlExpression, Formula1:= _
"=AND(A1,A3<>A10)"
Selection.FormatConditions(1).Font.ColorIndex = 3
End Sub
How do you keep A1 as a constant? I know that you could define a string and assign it the value of A1, but how would you add that in the format?