I have a sheet that has equipment IDs that are either in service, or
out of service.
One equipment ID can appear multiple times in column A (I recorded a
macro that sorts the rows on worksheet_change so they are grouped
together). What I would like to be able to do is run a macro that
opens an input box. Then the cells that match the input string are
selected and then the cell color and font is formatted (out of
service). I also need to be able to reverse this and remove cell
formatting (in service) based on the input string.
Can this be done from one input box where the user enters the equipment
ID, then selects either "in service" or "out of service"?
Thanks!