I am creating a time sheet and want to show negative values in red. Does
anyone know how to do this?
Thanks
Just set the condition to less tan and a value of 0 in CF.
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
quot;donaquot; gt; wrote in message
...
gt; I am creating a time sheet and want to show negative values in red. Does
gt; anyone know how to do this?
gt;
gt; Thanks
That's great, all sorted now, thank you
quot;Bob Phillipsquot; wrote:
gt; Just set the condition to less tan and a value of 0 in CF.
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from email address if mailing direct)
gt;
gt; quot;donaquot; gt; wrote in message
gt; ...
gt; gt; I am creating a time sheet and want to show negative values in red. Does
gt; gt; anyone know how to do this?
gt; gt;
gt; gt; Thanks
gt;
gt;
gt;
- May 16 Wed 2007 20:37
apply conditional formatting to negative cell values
close
全站熱搜
留言列表
發表留言