Hi Guys,
I'm new to VBA, so this problem might be not be really difficult, yet I cannot seem to find solution...
I'll just list what I need to do:
1. Conditional formatting needs to be applied to columns P and Q
=$Q1>$P1=> both cells turn red;
=AND($Q1=0,$P1>0) => both cells turn yellow.
2. Formatting needs to be applied only to rows where cell R is not empty (or where cell C is empty)
3. Number of total rows in range might be based on column B
Problem is that my recorded macro works properly only if I specify first cell that formatting needs to be applied to e.g. $Q12>$P12. I have no idea how to solve this...
I'm struggling with this long enough, can anybody help me?
Bookmarks