Excel VBA cell color change with conditions

Question

I'm kinda new at excel macro, and would like to learn how to do the following.

Let's say that I have column D as start date, column E as end date, and column J as status.

The content of J is 'Not Started', 'WIP' and 'Completed'

How can I set column J to display color changes when the following conditions are met: 1) Before Start date & not started color grey 2) within start and end date & 'WIP' color green 3) after end date & 'WIP' color red 4) within start and end date & ' not Started' color amber

Your assistance is much appreciated

Is my answer helpful for you?

keerti
– keerti

2016-12-21 11:56:47 +00:00
Commented Dec 21, 2016 at 11:56 — keerti
– keerti, Commented Dec 21, 2016 at 11:56

Community · Accepted Answer · 2017-05-23 12:13:57Z

1

You can add formulas on cells or create your own function to change cell color. For details please check the links given below -

https://www.ablebits.com/office-addins-blog/2013/10/29/excel-change-row-background-color/

Color cells based on their value - VBA

edited May 23, 2017 at 12:13

CommunityBot

11 silver badge

answered Nov 4, 2016 at 7:32

keerti

4652 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Excel VBA cell color change with conditions

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related