How do I change the colour of cells based on a start and end date?

**goodwinluke** · 08-11-2014, 04:14 AM

I am trying to set up a resource labour sheet using excel.

Instead of manually shading the cells myself, it would be great if I could configure excel to do it for me- based on the start date and end date of a given task.

-Please see the attached excel sheet as an example.

Not sure if this can be done, any help would be appreciated!

Thanks,
Luke

**TMS** · 08-11-2014, 04:36 AM

Select all the cells and use CF Formula:

Formula:

=AND(D$1>=$B3,D$1<=$C3)

Regards, TMS

**azumi** · 08-11-2014, 04:36 AM

Maybe something like this that you can work with?

**goodwinluke** · 08-11-2014, 05:57 AM

Thanks for the help guys, works a treat

**TMS** · 08-11-2014, 06:05 AM

You're welcome.

How do I change the colour of cells based on a start and end date?

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

How do I change the colour of cells based on a start and end date?

Re: How do I change the colour of cells based on a start and end date?

Re: How do I change the colour of cells based on a start and end date?

Re: How do I change the colour of cells based on a start and end date?

Re: How do I change the colour of cells based on a start and end date?

Thread Information

Users Browsing this Thread

Similar Threads

change start and end date based on userform entry

Change colour of cells based on another cell's colour (Not value)

Use VBA to change font colour of a cell based on its own value (date)

Change cell colour based on delivery date

how to change colour based on date

Bookmarks

Bookmarks

Posting Permissions