He (or she) would use that formula.

The way you write the rule may change--but the rule is the same. In fact, the
rule for D5 could have been written as:

formula is: =D5=123
or
value is: 123

I don't see a difference in the rule--there is a difference (obviously) in how
it's written.

????? (????) ????? wrote:

Hi, Dave,
If D5 CF was declared by its VALUE - "equal to" 123 .
How can he declare such a CF in cell A5 relying on D5 without using a
formula based CF in A5 - such as: =D5=123 !?
Micky

"Dave Peterson" wrote:

So D5 changes to red because of its conditional formatting?

Use the same rule(s) in A5 as what you used in D5. Change the formatting if you
want, but use the same rules.

LATC wrote:

How can I have Excel automatically change the color of a cell, for example
"A5" if "D5" is found to be the color RED due to a conditional format.

Automatically change A5 to the color RED, IF D5 is fould to be RED.

--

Dave Peterson
.


--

Dave Peterson