Hello,
I hope someone can help me. I'm not even sure if this is possible but here is what I'm looking to do. I have a worksheet where 2 columns have Conditional Formatting (columns H & I).
Column J's fill color should be based on Column H & I.
If Column H is green and Column I is green = Column J is green.
If Column H is Green and Column I is Yellow = Column J is red.
If Column H is Green and Column I is Red = Column J is red.
If Column H is Yellow and Column I is Green = Column J is yellow.
If Column H is Yellow and Column I is Yellow = Column J is red.
If Column H is Yellow and Column I is Red = Column J is red.
If Column H is Red and Column I is Green = Column J is red.
If Column H is Red and Column I is Yellow = Column J is red.
If Column H is Red and Column I is Red = Column J is red.
I'm assuming that this would be handled by VBA code which I am not familiar with. Any suggestions?
Thanks in advance!
Bookmarks