Forum Discussion
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 ...
What exactly is your need? I could not understand it.
What words do you want to highlight?
What words do you want to highlight?
- 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.
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?- 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, "<>*"). It would just be very helpful to have it in a map.
