close

If I have a cell in say column F that has either the value of 1 or 0 and I
want the rows of the cells that equal 0 to turn green and the rows that equal
1 to remain white. How should I approach that? Would it be conditional
formatting? Or something else?

Also, on the same line of questioning, if I want in column A a cell to equal
a value of quot;Matchquot; if the cell on the same row column F equals 1 what formula
would I need to use?

This is cond formatting, select col F, then Formatgt;Cond Formattinggt; then
decide value equal to 0, and select the shade of green you want.

quot;Bradquot; wrote:

gt; If I have a cell in say column F that has either the value of 1 or 0 and I
gt; want the rows of the cells that equal 0 to turn green and the rows that equal
gt; 1 to remain white. How should I approach that? Would it be conditional
gt; formatting? Or something else?
gt;
gt; Also, on the same line of questioning, if I want in column A a cell to equal
gt; a value of quot;Matchquot; if the cell on the same row column F equals 1 what formula
gt; would I need to use?

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

    software

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