Conditional Formatting on Multiple Sheets
Hello,
I am a Trainer for Amazon. It is my job to track any training that is performed within the building. I have my other trainers scanning Associate badge numbers into a sheet - one number per line. What I need is to have those numbers, after all are entered and saved, to match up with the corresponding badge number in my Associate Information Sheet.
For example: Jane just trained 10 Associates and scanned their badge numbers into rows 1-10 on the training tracker sheet. I would like to see if there is a way to have those 10 numbers entered fill the matching badge number cell within the Associate Information Sheet as a visual that they have been trained.
Is this possible to do? Thank you in advance for any assistance!
Best Answer
-
Hello @Lisa McMunn
Try this:
- Create a helper column (for example checkbox "Training Done" column) on your Associate Information Sheet
- Add this formula:
- =IF(HAS({Badge # Column in Training Tracker Sheet},[Badge #]@row),1,0)
This will check a row where the Badge # in the Associate Information sheet is found in the Training Tracker. Just make sure to change the correct references in the formula.
Melissa Yamada
melissa@insightfulsheets.com
Data made simple, spreadsheets reimagined
Answers
-
Hello @Lisa McMunn
Try this:
- Create a helper column (for example checkbox "Training Done" column) on your Associate Information Sheet
- Add this formula:
- =IF(HAS({Badge # Column in Training Tracker Sheet},[Badge #]@row),1,0)
This will check a row where the Badge # in the Associate Information sheet is found in the Training Tracker. Just make sure to change the correct references in the formula.
Melissa Yamada
melissa@insightfulsheets.com
Data made simple, spreadsheets reimagined -
Thank you!
That is exactly what I needed!!
Lisa
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66K Get Help
- 429 Global Discussions
- 149 Industry Talk
- 488 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 153 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!