C
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.
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.