Conditiona format based on format of another cell

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.
 
T

T. Valko

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
Conditional formatting. 1
conditional format of entire row based on a single cell in row 7
Link format along with contents of another cell 1
Function for summing or counting cells based on a specified fill color 2
conditionally formatting 3
Conditional format a column based on value in a different column 3
Using the Icon Set for Conditional Formatting 1

Top