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

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

Watch MrExcel Video

Forum statistics

Threads
1,127,518
Messages
5,625,271
Members
416,086
Latest member
CaptainGD

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