Highlighting Certain Words

Question

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 a formula or what conditional highlighting to use. I have attached a screenshot of my infection control log along with the sheet of the map that I am trying to create.&nbsp;

juliano-petrukio · Answer

What exactly is your need? I could not understand it.What words do you want to highlight?

laurenmcdonald · Answer

I’m trying to pull the information from the first chart, the “infection control log” over to the chart which is basically a floor plan of the facility. So I want to be able to highlight if room 529 had a uti, then I want UTI highlighted in yellow. If room 501 had a skin infection, I want it highlighted in pink.

juliano-petrukio · Answer

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 · Answer

Juliano-Petrukio&nbsp;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.&nbsp;&nbsp;I'm pulling the data from the room # column and the site column&nbsp;

laurenmcdonald · Answer

I've pulled this data already in chart form. Using the countifs formula. The exact formula I used was =COUNTIFS(Hall, "100", site1, "UTI", Hall, "&lt;&gt;*"). It would just be very helpful to have it in a map.

Forum Discussion

Highlighting Certain Words

7 Replies

Resources