Coloring a cell based off the color of another cell

  • Thread starter Thread starter Eric D
  • Start date Start date
E

Eric D

Is there a way for conditional formatting to recognize a color of a cell and
then color another cell if that color appears in a cell?

i.e. if D1 is colored RED, then H1 is colored either RED or a different color
 
Use Conditional formatting (formula is) on the "another cell" so what
ever the criteria in D1 is, use the same in H1 but use formula is,
instead of Cell value is.
 
how does this work in office 2007?
--
Eric


Bob I said:
Use Conditional formatting (formula is) on the "another cell" so what
ever the criteria in D1 is, use the same in H1 but use formula is,
instead of Cell value is.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top