Formatting

Conditional Formatting and Conditional Formulas

From http://office.microsoft.com/en-us/excel/HA010918321033.aspx

Conditional Formatting and Calculating Formulas

=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.

1. In cell D7, type =IF((TODAY()-B8)>30, "Overdue", "Current"), and then press ENTER.

2. Select cell D7, and then drag the fill handle over the range of cells that you want to display the message.

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."

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)

then choose Format color.

I think the $ anchors it so it will always refer to that column but change according to the row.

To copy to other rows use the paint brush called Format Painter next to th Copy and Paste icons

Use Formula Formula is then =$D2=1 or whatever the value and the cell is

Use Formula Formula is then '=$D2=1 or whatever the value and the cell is

Use Formula Formula is the =$D2=1 or what ever the value and the cell is

Highlight Rows then

Format

Conditional Formating

Use Formula '''Formula is" the =$D2=1 or what ever the value and the cell is

then choose Format color