Conditional formatting

[C]

I have a spreadsheet that contains subtotals. I would like to do conditional
formatting only on the rows that contain the work Total in column A. Coulumn
A may look similiar to:
Col A Col B Col C Col D
Arp 10 May 10 Jun 10
Widget 1 5 11 22
Widget 1 5 14 29
Widget 1 Total 10 25 51
Widget 2 1 1 2
Widget 2 Total 1 1 2


The month columns may run from B4:B10 or from B4 to B150. No set limit on
date range.

I need to be able to provide the following color coding for B4:???? for each
row that contains Total in A:

If cell = less than 15 Cell fill = yellow
If cell is between 16 and 20 Cell fill = green
If cell is between 21 and 35 Cell fill = blue
If cell is greater than 35 cell fill = red

I am using MS Excel Office Pro 2003.

Thanks in advance for you help.

 

[Don Guillett]

try formula=
=right(a1),5)="Total"

 

[C]

Hi Don,

I would prefer to do this via VBA and only color the cells that meet the
criteria and have Total in the a col.

 

[Don Guillett]

Use a FINDNEXT macro (look in vba help index)