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.

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

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

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" wrote:

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

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



.

Use a FINDNEXT macro (look in vba help index)
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

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

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

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



.