If D5 is red as a result of a conditional formatting, use an equivalent
condition for CF of A5.
If D5 is red as a result of manual formatting, you'll need VBA.

Colour functions:
a.. http://www.cpearson.com/excel/colors.aspx
b.. http://xldynamic.com/source/xld.ColourCounter.html
c.. http://www.ozgrid.com/VBA/Sum.htm

--
David Biddulph

"LATC" wrote in message
...
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.