Highlight Rows then
Format
Conditional Formating
Use Formula Formula is then =$D2=1 or whatever the value and the cell is
then choose Format color.
I think the $ anchors it so it will always refer to that column but change according to the row.
I now think you have the use =$d$1 to make it an "Absoloute Reference"
To copy to other rows use the paint brush called Format Painter next to th Copy and Paste icons
For alternating colors on a line
Use conditional formating with
=MOD(ROW(),2)
Conditional Formulas
=IF((DATEDIF(E2, $K$2, "d") > $L$5),((C2*$F$52)+(D2*$F$53)),0)
or
Display a message if a condition is true
You can display a message based on a value or the results of a calculation. For example, you may want to display "Overdue" for unpaid invoice items more than 30 days old.
If today's date is more than 30 days after the invoice date, the value of the cell is "Overdue." Otherwise, the value is "Current."
From http://office.microsoft.com/en-us/excel/HA010918321033.aspx