Schedule Analysis - Conditional format

[tripletsrock]

I am trying to analyze a monthly schedule for training. A cell will contain the room number and a time period (for example: 325B) where 325 is the room number and B is the time period. There are only five different time periods that can be attached to the end of the room number and they are A, B, C, D, E. If on one day the time period is D, the next day can not be A or B. If the time period is E, the next day can not be A, B, or C.

What I want to do is figure out if I can use conditional formatting to identify an error in the schedule.

For example: 325B 323D 323A 323C

I Would like the third cell to turn red since A cannot follow D.

Is this possible?

Thanks,

[mahju]

Hi
Assuming your first entry is in B5 use these formulae in conditional formatting

Select from B6 down as many cells as you want.

Please Login or Register  to view this content.

It should work.

Regards

[TMS]

If those values are in cells A1 to D1, use the following formula in cell B2:

=IF(LEFT(A1,3)<>LEFT(B1,3),"New Room",IF(B1>A1,"OK","Error"))

And drag down.

Regards