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?

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

software

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