The code listed in my original post was to change the cell that
contained the value.
Your original post made it seem that was your goal...: "cell value is
between 1 & 50 cell turns blue"

Let me understand, do you want to change the color of one cell (which
may be blank) based on the contents of another cell (that will be on
another sheet)?



More info, please.


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=472580