What you're looking for is to have *more* then 3 Conditional Formats.

First off, check out this link of John McGimpsey's:

http://www.mcgimpsey.com/excel/conditional6.html

This will show you how to use XL's formatting codes (*not* Conditional
Formatting) to color your displays according to the value in the cell.

Then, you can use Conditional Formatting to format the Pattern color of the
row based on the contents of Column A.

=LEN($A1)4

The Conditional Formatting (row colored Grey) will *not* override XL's
formatting codes.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"L S" wrote in message
oups.com...
Ok, here's my original conditional formulas (coming from 2 macros
written a while back):
Both of these format the numbers in E:H

Condition 1: (1 macro)
Cell value is < 0 color text red

Condition 2 and 3: (1 macro)
Cell value between 0.000001 and 0.01 color green
Cell value greater than 0.06 color yellow

These two macros work fine together.
Ok I just got a formula to work for the total lines- in every total
line column B is blank, so I just said =$B3=""
Unfortunately, the numbers in E:H lose the conditional formatting that
was stated earlier. I can run one of those macros again, but it goes
over the Total line formatting.
Is there a way to combine all of these things? Thanks again for your
help.