Conditional formatting on dates if another cell equals to

Hi,

I'm currently making a production planning sheet, and i have just reached a point where i'm facing some problems.

I have attached a picture of the sheet, so that my explanation of my problem is easier to understand.

My sheet books time in the calender for each production order based on dates, that works fine. Now i want to assign different production cells to each production order, and if i for instance type cell1 one in one of the cells under "PO assigned to cel", then i want to make the sheet automatically color the booked dates in calender with a given color. so far i have only been able to color the whole row red, i want it to only color the booked dates in the calendar.

If anybody could help on this matter, i would be very happy.

Welcome to the forum.

Will you please attach a sample Excel workbook? We are not able to work with or manipulate a picture of one and nobody wants to have to recreate your data from scratch.

1. Make sure that your sample data are REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

2. Make sure that your desired results are also shown (mock up the results manually).

3. Make sure that all confidential data is removed or replaced with dummy data first (e.g. names, addresses, E-mails, etc.).

4. Try to avoid using merged cells as they cause lots of problems.

Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

Please pay particular attention to point 2 (above): without an idea of your intended outcomes, it is often very difficult to offer appropriate advice.

One line of data is not enough to allow us to understand your logic. 10-20 lines of data is usually ideal. Please update the sample file (please ensure that there is a variety of data, not just the same line repeated).

This rule makes no sense:

=OR($D2="Cell1")

In words, what do you think it's doing?

Yes, but you haven't answered my question, really: what do you want it to do?

I'm good, but I'm not a mind-reader ...

Sort of - I think. Can you provide a version of the data with the cells manually filled in the way you want them to appear? A screenshot of this will suffice at this point.

OK - that makes sense now.

Get rid of all your rules and start again with the following three:

=AND($D2="Cell1",K2<>"")

=AND($D2="Cell2",K2<>"")

=AND($D2="Cell3",K2<>"")

Apply to the range $K$2:$U$20.

Tick the Stop if True box for each.

You're welcome!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.