Put your field/table names in as applicable, to the right is how it looks, I think this is what you're asking?

Here's the link to it if you want to see how it works. DLookup

Barry, the short answer is that this will NOT be easy to do in Access. Excel has a completely different set of Conditional Formatting tools available to it, and Access is Microsoft's red-headed stepchild, so its CF features are completely different and vastly underpowered. You could probably do this with some hidden query fields - sort them in order and then use DLookup and DMax to see if the previous field was the same, if not set the field to TRUE and then use a CF expression to check for that value, THEN set the CF. So, yes, it's possible, but it's nowhere near as easy as in Excel. This might make a cool TechHelp video. I'll add it to the (very long) list.

And I see what you're trying to do with your CF in the screen shot, but remember, you can't always count on AutoNumber being sequential. So unless you're typing those in yourself, you'll need to use DMax to find the greatest ID that's smaller than the current record. I'd use dates.

Yes, that looks like what I'm trying to do. Thank you!!

Richard, thank you! This is for a production schedule and it flags the operator when he will have to change the tool. In Excell you can check the number to the one above but not so easy in Access.