Conditional Formatting on one cell based on value in another

M

MJatAflac

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

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

Thanks, as always you guys are the best!
 
G

Gord Dibben

Select A1

Format>CF>Formula is: =C1>50

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
 
G

Gord Dibben

Even with the horrible grammar?

"make sure Excel where you place"

Thanks for the feedback.

Exactly what I needed!

Thanks!
Click to expand...

Gord Dibben MS Excel MVP
 
Top