Can I colour the response from a calculation?
 

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

Can I colour the response from a calculation?
 

Hi Brian

Use Conditional Formatting.
Highlight the cells concernedformatConditional FormattingCell Value
isBelow40%Select Format required.


--
Regards
Roger Govier

"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

Can I colour the response from a calculation?
 

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

Can I colour the response from a calculation?
 

Thsnks Roger that did the trick.

"Roger Govier" wrote:

Hi Brian

Use Conditional Formatting.
Highlight the cells concernedformatConditional FormattingCell Value
isBelow40%Select Format required.


--
Regards
Roger Govier

"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

Can I colour the response from a calculation?
 

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