Forum Discussion
LaurenMcDonald
Aug 27, 2021Copper Contributor
Highlighting Certain Words
I'm very new to excel and I need a little help. I've created this table that tracks infections in the facility that I work in. I'm trying to get excel to map the data for me. I cant quite figure out ...
Juliano-Petrukio
Aug 27, 2021Bronze Contributor
I guess I understood and I have some ideas on how to assist you.
To be more practical, is possible you just provide some sample like the data of your screenshots?
LaurenMcDonald
Aug 27, 2021Copper Contributor
I'm attaching some screenshots where I have gone in and highlighted it myself. I can continue to do it manually but I was really looking for a formula to do it faster.
I'm pulling the data from the room # column and the site column