Hi,
In the CF of A5, try to use a Formula instead of a Value in order to "fire"
the Conditional Format, based on cells D5 Value.
Micky

"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.