Format bases on IF Statement

[JUAN]

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

 

[Frank Kabel]

Hi
try the following
- select your range (e.g. A1100)
- goto 'Format - Conditional Format'
- enter the formula
=ISNUMBER(FIND("Total",$A1))
- choose your format

 

[Rob van Gelder]

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

 

[Frank Kabel]

Hi
but if I unerstood you you only check column A for the word 'Total'.
Therefore I used a mixed aboslute reference like
$A1
that is always checking column A. But maybe I'm missing something here.
You may repost with an example row of data and state your expected
result for all columns