simple find

[tcpteacher]

I have a seating chart with a cell I don't see a formula for. I can
enter the seat number (ex. 12345) into the cell (B1) and it will move
to and highlight the corresponding cell within the sheet which enables
me to locate the seat within a room. I need to duplicate this for
another workbook. What is the formula?

 

[tcpteacher]

Skip it- I figured it out. Basic conditional formatting. Silly me.

 

[Don Guillett]

See how just posting to this group helps