-
Not my actual final goal, but laying out the logic- here is what I have. My code errors at the "and"
[VBA]
For i = 1 To Lrow
If Cells(i, "F") = "Hat" Or Cells(i, "F") = "Shoe" _
and if Cells(i, "M").numberformat = "0.0" Then
Cells(i, "M").interiorfill = vbYellow
End If
End If
Next i
[/VBA]
my site: www.ecboardco.com
was built w/ a majority of the assistance from the board members here... thanks VBAX.
Just because I see something, doesn't mean that what's actually happening is what I see.
You don't get from 0-90 by standing still!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules