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?
- Jun 22 Fri 2007 20:38
conditional formatting?
close
全站熱搜
留言列表
發表留言