Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select multi cells and format
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Select format cells Custom but Saves As Specil Why. | Excel Worksheet Functions | |||
Multi Select Cells | Excel Programming | |||
When I select "format cells", the format dialog box does not disp. | Excel Worksheet Functions | |||
Select cells by format with VBA | Excel Programming | |||
Extract values from a multi-select multi-column list-box | Excel Programming |