ExcelBanter - Microsoft Excel

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Microsoft Excel (https://www.excelbanter.com/excel-discussion-misc-queries/77682-microsoft-excel.html)

Andrew1224

Microsoft Excel

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

ewan7279

Microsoft Excel

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?

All times are GMT +1. The time now is 02:52 PM.