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?
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?