Thread: Changing the color of a cell based on the color of another cell.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default Changing the color of a cell based on the color of another cell.
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
Reply With QuoteReply With Quote