Hi Andrew,

Format = Cells = Custom, and in the Type bar enter: "0.00_ ;[Red]-0.00"
(without the quotation marks.

Ewan.

"Andrew1224" wrote:

How can I get text to be shown in red if the value is less than 0.00?