Comnditional formatting problem

[howard]

I have a spreadsheet with the following heading

Volvo Veh Debtors.xls
	A	B	C	D	E	F	G	H	I	J	K	L
1	AccountNo	Customer	FinancedBy	AccountBalance.	0-5Days	6-10Days	11-15Days	16-30Days	60Days	90Days	120Days	150+Days
Sheet1

The data will appears in column A:L

Where the value in column F to L is greater than zero ,then the entire row containing these value must be highlighted, except the finalrow as this contains "totals" where is in col Column B

Your assistance in this regard will be most appreciated

 

[GlennUK]

=AND(SUM($F2:$L2)>0,UPPER($B2)<>"TOTALS")

should do it ( when you select A2 up to column Ls last row before applying CF ).

 

[howard]

Hi Glenn

Thanks for the help, much appreciated