Conditionally highlight a row on a cell content

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

John - 29 May 2008 00:20 GMT

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

Reply to this Message

Spiky - 29 May 2008 17:34 GMT

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

Reply to this Message