Colour cells in columns i & u to ae, based on c & i

outlook

Board Regular
Joined
Jun 16, 2010
Messages
93
Hi,

I wonder if someone can help me as I'm tearing my hair out ...

I need to colour the cells in columns I, and U to AE. The colour depends on what text is found in C and I.

For example ...

If C6 = "LAND" and I6 = "Intro", I6 & V6 needs to be coloured brown.

Can this be done, or am I just asking too much? I've tried conditional formatting but it doesn't allow enough varients.

Thank you.
 

Some videos you may like

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

outlook

Board Regular
Joined
Jun 16, 2010
Messages
93
I am using 11 colours between column U & AE.

I am using a minum of 2 conditions per colour.

I hope this answers your question, as it's difficult to explain.
 

delaneyjm

Well-known Member
Joined
Apr 22, 2009
Messages
624
Okay, can you define your conditions for me and what colors each condition would be?
 

outlook

Board Regular
Joined
Jun 16, 2010
Messages
93

ADVERTISEMENT

"I" contains "Refund" but not included in any other conditions below = Pink

"C" contains "LAND" and "I" contains "Intro" = Brown

"C" contains "LAND" and "I" contains "Homelet Charge" = Red

"C" contains "LAND" and "I" contains "Management" or "Monthly Fee" = Orange

"C" contains "LAND" and "I" contains "Continuation" = Yellow

"C" contains "LAND" and "I" contains any other text not included in "LAND" catagories above = Light Green

"C" contains "TENC" and "I" contains "Admin" or "Contract" = Dark Green

"C" contains "TENC" and "I" contains "Continuation" or "Card Handling" = Light Blue

"C" contains "CONT" and "I" contains "Commission" or "Hallmark" = Bright Blue

"I" contains any other conditions not covered in any of the above = Navy Blue
 

delaneyjm

Well-known Member
Joined
Apr 22, 2009
Messages
624

ADVERTISEMENT

What version of Excel do you run? If you are running 2003 or older, only 56 colors are available. If you want to see a list of colors that are available in those versions run this macro first on an empty worksheet and then post back.

Code:
Sub colors56()
    Application.ScreenUpdating = False
    
    Dim i As Long
    
    For i = 0 To 56
        Cells(i + 1, 1).Interior.ColorIndex = i
    Next i
    
    Application.ScreenUpdating = True
End Sub
 

outlook

Board Regular
Joined
Jun 16, 2010
Messages
93
Hi,

I'm running 2007, and by running the macro you gave me, I get 56 colours back.

Thanks.
 

Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Threads
1,106,868
Messages
5,513,898
Members
408,975
Latest member
PaperRave

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top