Can someone tell me what the Conditional Formatting formula would be to do what is shown in the screenshot below? There are 18 boxes showing. If the number 15 is typed into the top left box, then box number 15 will be highlighted. If the number 1 is typed in, then the box number 1 will highlight, etc.
The top left box is a number field. And each of the 18 boxes are defined as number fields; ie., Box 1; Box 2; Box 3, etc.
I know this should be really easy, sorry to be so dumb :)