Conditional Formatting on one cell based on value in another
 

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

Conditional Formatting on one cell based on value in another
 

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!

Conditional Formatting on one cell based on value in another
 

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!

Conditional Formatting on one cell based on value in another
 

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