How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • Go back-and-forth until satisfied
    Rate the answer you receive.
By continuing to use this site you consent to the use of cookies on your device as described in our cookie policy unless you have disabled them.
Ask Ameen Khan Your Own Question
Ameen Khan
Ameen Khan,
Category: Programming
Satisfied Customers: 12221
Experience:  Senior IT Support Specialist at Brookfield Asset Management
101830517
Type Your Programming Question Here...
Ameen Khan is online now

I wish to colour a cell which contains a month name. I have

Customer Question

I wish to colour a cell which contains a month name. I have a list of months and the corresponding colours on another sheet. How can I do this in code?
JA: What programming language are you using for this assignment?
Customer: vba
JA: What are the full requirements for this task? How soon do you need it completed?
Customer: I am making a workbook to organise our holidays.Every 1st Monday in April starts a new year and a new chart based on the previous year is needed. Each month has its own colour which I have in a list.I want to transfer the colour in the list to the merged cells which contain thhe months name. Time? The sooner the better.
JA: Anything else you want the Programmer to know before I connect you?
Customer: no
Submitted: 2 years ago.
Category: Programming
Customer: replied 2 years ago.
The sort of code I am looking for would be Index/match where I have a list of months in one column and in an adjacent column there would be 12 cells each coloured. And the code would be INDEX(Column of colours,Match(Month,List of month names,0)) But I have not been able to make that work .
Expert:  Ameen Khan replied 2 years ago.

Hi! My name is Ameen and I'll be assisting you. Secure Remote Assistance is NOT REQUIRED (But Helpful)

I am sorry you are having this concern, I will do my best to help you today.

To answer your question ->

​Follow the steps from this link below for the VBA

-------------

Let me know if you have any follow up questions. I am here to help you.

Ask Your Own Programming Question