What nobody has mentioned here is that you must FIRST select the range
you want formatted before you can use conditional formatting.

I had to search TWICE and experiment for about 10 minutes (with 100%
failure rate) to find that out.

Too bad MS fails to mention pretty crucial stuff like that right up
front, eh?

Their help-search algorithm is apalling.

Then again, my needs are nothing compared to their deisre for total
world domination.

Have a good one.

Mark
Boston


--
LTUser54
------------------------------------------------------------------------
LTUser54's Profile: http://www.excelforum.com/member.php...o&userid=33459
View this thread: http://www.excelforum.com/showthread...hreadid=533751