Conditional Formatting Anomaly

I'm using the formatting paintbrush to copy a conditional format to
multiple cells. The format is based on 2 conditions. The first
condition turns the cell blue if the number is 1% higher than the base
cell in column B. The second condition turns the cell yellow if it is
1% higher than the base cell in column B. The cells which fall in
between the +1% and -1% will stay unformatted.

When I copy the format with the paintbrush, the cells that should be
unformatted turn a color (yellow or blue). There are external links
(not to the conditional formatting) if that makes a difference. Other
than that, I don't see any reason why it shouldn't work. If I go into
the conditional formatting and retype the conditional format in, it
works.

Here is the equation....

Format 1.
if cell value is greater than $B1+.01 than turn blue

Format 2.
if cell value is less than $B1-.01 than turn yellow

I have no idea why this doesn't work when I copy it.

Please HELP!


--
Rutgers_Excels
------------------------------------------------------------------------
Rutgers_Excels's Profile: http://www.excelforum.com/member.php...fo&userid=8973
View this thread: http://www.excelforum.com/showthread...hreadid=274324

I expect you want to make that $B$1
which would always compare you to the same cell.

My page on Conditional Formatting is
http://www.mvps.org/dmcritchie/excel/condfmt.htm

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Rutgers_Excels" wrote in message ...

I'm using the formatting paintbrush to copy a conditional format to
multiple cells. The format is based on 2 conditions. The first
condition turns the cell blue if the number is 1% higher than the base
cell in column B. The second condition turns the cell yellow if it is
1% higher than the base cell in column B. The cells which fall in
between the +1% and -1% will stay unformatted.

When I copy the format with the paintbrush, the cells that should be
unformatted turn a color (yellow or blue). There are external links
(not to the conditional formatting) if that makes a difference. Other
than that, I don't see any reason why it shouldn't work. If I go into
the conditional formatting and retype the conditional format in, it
works.

Here is the equation....

Format 1.
if cell value is greater than $B1+.01 than turn blue

Format 2.
if cell value is less than $B1-.01 than turn yellow

I have no idea why this doesn't work when I copy it.

Please HELP!


--
Rutgers_Excels
------------------------------------------------------------------------
Rutgers_Excels's Profile: http://www.excelforum.com/member.php...fo&userid=8973
View this thread: http://www.excelforum.com/showthread...hreadid=274324