If I have a sheet which in one column has targets and in the next has
actuals, how can i enter one type of conditonal formatting to ensure it
colours depending on result?

Jez

Jez

Assuming you want to color an actual if it doen't meet target.

Assuming targets are in column A and actuals in column B.

Select column B or as much of column B as you need.

FormatCFformula is:

Condition one....=IF($B1="","",$A1$B1) format to blue

Condition two....=IF($B1="","",$A1<$B1) format to red


Gord Dibben Excel MVP

On Fri, 28 Jan 2005 13:19:01 -0800, Jez wrote:

If I have a sheet which in one column has targets and in the next has
actuals, how can i enter one type of conditonal formatting to ensure it
colours depending on result?

Jez