Conditionally highlight a row on a cell content

[John]

I have a large Excel 2007 table of items showing budgets, actuals, variances
and % variances. How do I highlight row text and background coloring whenever
the row % variance cell is less that -50% (ie, the row is more than 50% over
budget).

 

[Spiky]

I have a large Excel 2007 table of items showing budgets, actuals, variances
and % variances. How do I highlight row text and background coloring whenever
the row % variance cell is less that -50% (ie, the row is more than 50% over
budget).

Conditional formatting can do this quite easily. Select the top row of
data, goto Conditional Formatting, enter a formula like "=B2<-.5", and
choose your highlighting format. Copy formats only down to each row in
the table.