close

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

Hi Andrew,

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

Ewan.

quot;Andrew1224quot; wrote:

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

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()