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