Probably a matter of not choosing the cells in the formula relative
to the active cell and your selection. Read (especially red lettering in)
http://www.mvps.org/dmcritchie/excel/condfmt.htm

Then try again. You will have to adjust the formula Don supplied to meet
your needs. Also you realize that your response is vague. So if you can
describe what it does instead of working you'd be ahead of the game.
Of course that is not always possible.
---
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

"elew" wrote in message
...

This does ot seem to do it. I have tried this in both Formula and Cell
Value


--
elew
------------------------------------------------------------------------
elew's Profile: http://www.excelforum.com/member.php...o&userid=25059
View this thread: http://www.excelforum.com/showthread...hreadid=385830