Hello,
I created a subtotal using excel's Subtotal option.
Example,
DIV NAME2 NAME3 NAME4 QTY Ext
TEST1 JX JY JQ 42 52
TEST1 Total 42 52
TEST2 JX JY JQ 54 60
TEST2 Total 54 60

So I want to format Col A,B,C and D only if Row equals
TEST1 Total.
So something like thits
If A:A="TEST Total" Or "TEST2 Total" Then format Col A,B,C
D only for that row. Etc....

Hope this makes sense,
Please advise any info, would appreciate it alot.
Juan