for column of pivot, I have a bunch of currency symbols...e.g.,
CAD
CAD
CAD
CAD
CAD
USD
USD
KRW
KRW
KRW
-the currencies can change daily
-pivot starts at row 3, ending row changes daily
-columns A to E (fixed)
-what I want via VBA (or excel if possible) is to have the body for each currency to have a different color
e.g.,
if range A3 to E10 are "CAD" rows, color it yellow
if range A11 to E20 are "USD" rows, color it blue
if it's not possible to do this UNLESS the currencies do not repeat (i.e., repeat labels turned off), then I'm OK with that
CAD
CAD
CAD
CAD
CAD
USD
USD
KRW
KRW
KRW
-the currencies can change daily
-pivot starts at row 3, ending row changes daily
-columns A to E (fixed)
-what I want via VBA (or excel if possible) is to have the body for each currency to have a different color
e.g.,
if range A3 to E10 are "CAD" rows, color it yellow
if range A11 to E20 are "USD" rows, color it blue
if it's not possible to do this UNLESS the currencies do not repeat (i.e., repeat labels turned off), then I'm OK with that