Conditional Formatting formula to combine individual entries

BigGee

New Member
Joined
Sep 8, 2020
Messages
6
Office Version
  1. 2019
Platform
  1. Windows
Hello,

I am hoping that someone may be able to assist.

I am trying to modify a template to use as a resource planner. I am able to create a chart as below with the individual tasks allocated to resources, but I cannot seem to get my conditional formatting formula to work to plot all of the tasks for an individual resource eg Resource A onto a single row eg Row 8.
Is there a way of doing this?

I have been playing around with something like =IF(D$10:D$14="D8",AND(task_end>=K$5,task_start<L$5)), but havent been getting anywhere close to a solution I am afraid.

I have been able to find a way (separately) of identifying any overlapping work periods, (using IF statements to create a list and then SUMPRODUCT conditional formatting, but if there was a way of incorporating that into the conditional formatting too then that would be perfect!

Any help would be greatly appreciated.

Regards



1603395869431.png
 

Some videos you may like

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

Watch MrExcel Video

Forum statistics

Threads
1,126,965
Messages
5,621,860
Members
415,862
Latest member
nascaline

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top