color a cell based on the colors in two other

Microsoft Excel 2010
July 22, 2010 at 22:53:18
Specs: Windows 7
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?


See More: color a cell based on the colors in two other

Report •


#1
July 24, 2010 at 16:23:37
UP

Any help please?


Report •

#2
July 24, 2010 at 16:56:40
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

http://www.skeptic.com/


Report •
Related Solutions


Ask Question