close

Here's what I want to do.........if any number in a specified column is gt; a
specified value, I want to highlight the cell or quot;fillquot; the background of
that cell with a specified color, and present that number in bold-face. Can
anyone tell me how to do this?

Look up conditional formatting in help.

--

HTH

RP

quot;Richardquot; gt; wrote in message
...
gt; Here's what I want to do.........if any number in a specified column is gt;
a
gt; specified value, I want to highlight the cell or quot;fillquot; the background of
gt; that cell with a specified color, and present that number in bold-face.
Can
gt; anyone tell me how to do this?
under the formatting menu there is conditioning formatting and you can put
multi conditions from bold to color background.

B.

quot;Richardquot; wrote:

gt; Here's what I want to do.........if any number in a specified column is gt; a
gt; specified value, I want to highlight the cell or quot;fillquot; the background of
gt; that cell with a specified color, and present that number in bold-face. Can
gt; anyone tell me how to do this?

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

    software

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