hmm,

I tried this and woohoo it does work only it doesnt work...

I figured out why tho, the values I want to format are all being pulle
in via a lookup, is there anyway to make excel think they are just ther
and not part of a formula

--
chrisrowe_c
-----------------------------------------------------------------------
chrisrowe_cr's Profile: http://www.excelforum.com/member.php...fo&userid=2522
View this thread: http://www.excelforum.com/showthread.php?threadid=39207