Hello guys… I want to color a cell based on the colors in two other cells. There are 4 cases;

Case 1: IF A1 is red and B1 is red, THEN C1 is green.

Case 1: IF A1 is green and B1 is green, THEN C1 is green.

Case 1: IF A1 is red and B1 is green, THEN C1 is red.

Case 1: IF A1 is green and B1 is red, THEN C1 is red.Any help?

UP Any help please?

If A1 and B1 are colored using Conditional Formatting,

then combining the logic of the two cell for Cell C1 is the only way I can think of.If A1 and B1 are not colored using Conditional Formatting, then the only way MAY be using VBA.

MIKE

Ask Your Question

Weekly Poll

Did you buy anything on Amazon's Prime Day?

Discuss in The Lounge

Poll History