Having bold and colored for the same condition does not mean you have
to have seperate formulas.

You may have had both row and column Absolute........$M$2........when
you just need the column Absolute...........$M2 so all rows will look
at column M


Gord

On Thu, 10 May 2012 19:17:41 +0000, kaori
wrote:

Thank you! The formula worked! I also realized that it might not have
been working because I was trying to do 2 formatting tasks at once. It
worked better when I did the bold in one formula and the border line in
another.