|re: "when i am trying to use cells with conditional formatting"|
Why do you mention conditional formatting?
I don't see anyting related to conditional formatting in your code.
If (IsEmpty(Cells(i, "A") = False) & (Cells(i, "B").Value.Count > 1)) Then
There is so much that is confusing about that line.
1 - There must be more to your code, since I don't see i being set to anything before it is used in that line.
2 - What is the purpose of the &?
The & is used to concantenate strings and/or strings and variables in VBA.
e.g. This will place Goodbye for now. in A4
myRw = 4
myStr = "for"
Range("A" & myRw) = "Goodbye " & myStr & " now."
The way you are using it makes no sense to me.
3 - Cells(i, "B").Value.Count > 1
What is that supposed to do?
Cells(i, "B").Value is going to return the value in Cells(i, "B").
There is nothing for VBA to count.
You'll need to explain what you are trying to do before we can begin to offer suggestions on how to modify your code.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.