View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
LATC LATC is offline
external usenet poster
 
Posts: 2
Default Changing the color of a cell based on the color of another cell.

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.