Results 1 to 4 of 4

Change Cell Fill Color Based on Colors in 2 Columns

Threaded View

  1. #1
    Registered User
    Join Date
    11-03-2010
    Location
    Canton, MA
    MS-Off Ver
    Excel 2003
    Posts
    3

    Change Cell Fill Color Based on Colors in 2 Columns

    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!
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1