Help needed with conditional formatting

[claustro]

Hi,
I am a total beginner at Excel.

I have a hospital timesheet structured as follows:

• First Raw -> days
• First Column -> duties. Duties can be in the morning, night, evening, or ready for availability. I indicated the type of turn in columns AR and AU as M= morning P= evening N = night R = availability
• Cells -> workers

I would like conditional formatting that prevents me from putting a worker on a morning turn (M) the day after an availability turn (R)

Thank you very much !

 

[Peter_SSs]

Duplicate to: Conditional formula , maybe simple but I am stuck.

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.