lights

I have an inventory of 550 emergency exit lights that must be tested every month. I'm finding my testers are not actually testing the lights but just checking them off on a printed spreadsheet. I want to install barcode stickers on the lights so they have to go to each light to verify...

I have code that High Lights Duplicates in a Workbook. Out of the 12 sheets only 7, I want to find dup's. All 7 are formatted as Table's and are identical. It also high lights the tab when one is found. It works perfect but I cant figure out how to exclude 4 of the sheets. Columns are A - T and...

Hello, I need a formula to count icons within a range. I have a large table of data. Each row has unrelated data for which i have created conditional formatting. They are either red lights or green lights. I would like to count the number of each lights in the last column in the range which has...

I'm creating an automated sheet for a rather rude colleague and as a bit of fun I've made it so if she types an incorrect value in a table, the table then flashes red and blue like police lights, I want to have a pop-up box that informs her the value is incorrect but the issue is this interrupts...

I have a Database where I keep track of tooling inventory I usually paste a LineArt drawing from AutoCadLt into a table called ToolType Recently when I try and paste into the table, the Edit pencil lights up, but nothing. Any ideas? Microsoft Access Microsoft Office Professional Plus 2013