Apply this conditional formatting to cell A1
Formula is =RIGHT($A1,6)=" Total"
Font = Red (or whatever format you wanted)

Then copy A1
Select all cells
paste special: formats

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"JUAN" wrote in message
...
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