Table space is from "A" to "h" coordinate on y axis (8 coordinates), and 1 to 5 coordinate on x axis. Making a total of 40 spaces (or vice versa, not that important if letters on y or x)
Batch numbers can vary from 0 to 40 different batches that can change weekly or daily, some remain more time than others.
I have automated the process of traceability recording for the batch numbers, simplifying it with VBA userforms, but can't find a way to visually demonstrate their positions on the tables.
IMO conditional formatting can't be that dynamic (or at least I don't think so), cause the user has to be blocked to just use the forms.