Conditional formatting

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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top