I am trying to make a spread sheet for work with a list of medications for
our patients. I want to be able to have excel highlight the meds that we do
not cover. I figured that if I made a list of all the meds and then in
another column, write in all the meds that we do not cover. Then somehow have
excel highlight all the meds in the "meds not covered" column be highlighted
in the "all meds" column. Does anyone know if this can be done? Or if there's
another way that might be useful? Thanks a bunch!!