Conditional Formatting to Highlight Subtotals

[howard]

I would like highlighlight my subtotals in blue using condtional formatting.

It would be appreciated if someone could assist me-see Sample data below

Conditional Formatting Subtotals.xls
	A	B	C	D	E	F	G
5	City	Campaign	Month	Cost	QuantityRedeemed	ResultingSales	Profit/(Loss)
6	CapeTown	Internet	April	36,000	299	142,324	106,324
7	CapeTown	DirectMail	January	66,000	78	37,128	(28,872)
8	CapeTown	Internet	July	9,900	276	131,376	121,476
9	CapeTown	DirectMail	October	37,500	61	29,036	(8,464)
10	CapeTown	RadioSpot	April	36,000	299	142,324	106,324
11	CapeTown	DirectMail	January	66,000	78	37,128	(28,872)
12	CapeTown	LocalAds	July	9,900	276	131,376	121,476
13	CapeTown	DirectMail	April	28,500	17	8,092	(20,408)
14	CapeTown	DirectMail	October	26,400	455	216,580	190,180
15	CapeTownTotal			316,200		875,364	559,164
Sheet1

 

[VoG]

Try like this

Excel Workbook
	A	B	C	D	E	F	G
6	City	Campaign	Month	Cost	Quantity Redeemed	Resulting Sales	Profit/(Loss)
7	Cape Town	Internet	April	36,000	299	142,324	106,324
8	Cape Town	Direct Mail	January	66,000	78	37,128	-28,872
9	Cape Town	Internet	July	9,900	276	131,376	121,476
10	Cape Town	Direct Mail	October	37,500	61	29,036	-8,464
11	Cape Town	Radio Spot	April	36,000	299	142,324	106,324
12	Cape Town	Direct Mail	January	66,000	78	37,128	-28,872
13	Cape Town	Local Ads	July	9,900	276	131,376	121,476
14	Cape Town	Direct Mail	April	28,500	17	8,092	-20,408
15	Cape Town	Direct Mail	October	26,400	455	216,580	190,180
16	Cape Town Total			316,200		875,364	559,164
Sheet5

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A7	1. / Formula is =RIGHT($A7,5)="Total"	Abc

 

[howard]

Hi Peter

Thanks for the help, much appreciated

Regards

Howard