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

Excel does not accept text format! 0
Function for summing or counting cells based on a specified fill color 3
Conditional Formatting Less Than Today Week Days only 0
Referencing the values of multiple cells in conditinal formatting. 0
Conditional formatting. 1
Conditional Formatting to Another Cell 0
conditional format of entire row based on a single cell in row 7
Using the Icon Set for Conditional Formatting 1

Top