conditional formatting?
 

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 "Match" if the cell on the same row column F equals 1 what formula
would I need to use?

conditional formatting?
 

This is cond formatting, select col F, then FormatCond Formatting then
decide value equal to 0, and select the shade of green you want.

"Brad" wrote:

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 "Match" if the cell on the same row column F equals 1 what formula
would I need to use?