T Tami Dec 18, 2009 #1 can i conditionally format a cell based on the shading of another cell. e.g. i cell A1 is green shade C1 green.
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 Dec 18, 2009 #2 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.
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.
