Conditionally highlight a row on a cell content

J

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).
 
S

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).
Click to expand...

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