Conditiona format based on format of another cell

  • Thread starter Thread starter Tami
  • Start date Start date
T

Tami

can i conditionally format a cell based on the shading of another cell.

e.g. i cell A1 is green shade C1 green.
 
If A1 is conditionally formatted use the same rule to apply cf to C1.

If A1 isn't conditionally formatted then why is A1 colored green?

Use the logic of *WHY* A1 is green to apply the cf to C1.
 

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

Similar Threads

Comparison of columns using Conditional Formatting 3
Coonditional formatting 3
Link format along with contents of another cell 1
Multiple cell conditional formatting using the IF 3
conditionally formatting 3
Function for summing or counting cells based on a specified fill color 2
macro to disallow shading in certain columns 2
Conditional formatting. 1

Back
Top