Thanks Jim that did the trick
"Jim Cone" wrote:
Brian,
Conditional Formatting (Format menu) or a Custom Number Format will do it.
Also, helpful newsgroup posting tips here... http://www.cpearson.com/excel/newposte.htm
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)
"BrianC500"
wrote in message
I would like to know if it is possible to have the response from a
calculation in colour. i.e. In week 1 I need 40% of my monthly target. If my
sales figure is below 40% I need the result shown in red. is this possible?
Thanks in advance
Brian