Conditional Formatting Question

[TJPCTeach]

Good Morning:
I am trying to use Conditional Formatting; I have a cell that has the background fill color red in cell A3. In cell A20 I want to use conditional formatting, I have the color list of all background colors. Red is #3. So when I'm in cell A20 with the conditional formatting open and it ask for conditional 1, what do I enter so that it look at the color red in cell A3 and then I can make the format change in Cell A20 with what I want. I hope this is clear. Thanks...........

 

[NBVC]

Why not just choose the colour from the palette that Excel offers you in the Conditional Formatting dialogue box? Click Format and then Select the Pattern Tab, you will see the colours there.

In the formula box, you insert the condition you want met in order for that selected colour to appear in the cell background.

 

[Von Pookie]

You can't. You would have to tell it to look at the *value* of A3.

Basically: if the color of A3 is based off a condition, you would set A20 to check for that same condition in A3.

For example: A3 is conditionally formatted to turn to red if the value in A3=3.

A20 would then use the condition =$A$3=3 to turn red.

If A3 is manually colored and not based off of any condition (that is, there is no data you can use to base the condition of A20 off of), you would have to use a macro.

 

[TJPCTeach]

Thanks for the informatin.