HI Tom,

Thanks for the reply. Prob is, this shows no value. The user inputs a
qty in G1 which returns a value to b1, based on a price in a1. I dont
want the user to see the end value but would like something to show
that a value exists. If nothing, then nothing shows. Maybe code that
states if the cell value is 1, then the cell colours????

Thanks Tom!!!


--
gavmer
------------------------------------------------------------------------
gavmer's Profile: http://www.excelforum.com/member.php...fo&userid=6662
View this thread: http://www.excelforum.com/showthread...hreadid=262249

if b1 has a value and I want to see it, I can go to another cell and do

=B1

If you want to color the font or the color, use conditional formatting.

--
regards,
Tom Ogilvy

"gavmer" wrote in message
...

HI Tom,

Thanks for the reply. Prob is, this shows no value. The user inputs a
qty in G1 which returns a value to b1, based on a price in a1. I dont
want the user to see the end value but would like something to show
that a value exists. If nothing, then nothing shows. Maybe code that
states if the cell value is 1, then the cell colours????

Thanks Tom!!!


--
gavmer
------------------------------------------------------------------------
gavmer's Profile:
http://www.excelforum.com/member.php...fo&userid=6662
View this thread: http://www.excelforum.com/showthread...hreadid=262249