Is there a way to apply conditional formatting to one cell based on the value
in a different cell?

IE: If C150 the A1 is green if A1<=50 then A1 is unchanged.

Thanks, as always you guys are the best!
--
Michal Joyce
Project Management IS Analyst
Aflac - Project Management Office

Select A1

FormatCFFormula is: =C150

Format to Green.

The <=50 will look after itself.

If you intend to copy this formatting to other cells make sure Excel where you
place the $ signs around C1

You may want to edit to $C1 to copy formatting down column A so it increments to
$C2, $C3 etc.

Or C$1 so it increments to D$1 etc. as you copy formatting across a row.


Gord Dibben MS Excel MVP

On Wed, 1 Nov 2006 13:46:03 -0800, MJatAflac
wrote:

Is there a way to apply conditional formatting to one cell based on the value
in a different cell?

IE: If C150 the A1 is green if A1<=50 then A1 is unchanged.

Thanks, as always you guys are the best!

Exactly what I needed!

Thanks!
--
Michal Joyce
Project Management IS Analyst
Aflac - Project Management Office


"Gord Dibben" wrote:

Select A1

FormatCFFormula is: =C150

Format to Green.

The <=50 will look after itself.

If you intend to copy this formatting to other cells make sure Excel where you
place the $ signs around C1

You may want to edit to $C1 to copy formatting down column A so it increments to
$C2, $C3 etc.

Or C$1 so it increments to D$1 etc. as you copy formatting across a row.


Gord Dibben MS Excel MVP

On Wed, 1 Nov 2006 13:46:03 -0800, MJatAflac
wrote:

Is there a way to apply conditional formatting to one cell based on the value
in a different cell?

IE: If C150 the A1 is green if A1<=50 then A1 is unchanged.

Thanks, as always you guys are the best!

Even with the horrible grammar?

"make sure Excel where you place"

Thanks for the feedback.

On Wed, 1 Nov 2006 14:20:02 -0800, MJatAflac
wrote:

Exactly what I needed!

Thanks!

Gord Dibben MS Excel MVP