| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
writing macro to gray out cells automatically
I need to write a macro that will do the following
If there is a check-mark symbol in a given cell on a row of data, all cells preceeding the check-mark cell will be grayed out. If the check-mark symbol is problematic, I can possibly pursuade my coworker to enter a certain alphanumeric character in the cell instead. For example: Row 9, column H has the checkmark or other "flag" Column a - g would be grayed out on that line only when the macro is run |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatically gray out rows when a particular field is populated | Excel Discussion (Misc queries) | |||
| Automatically gray out a row when a particular field is populated | Excel Discussion (Misc queries) | |||
| writing a macro that automatically opens another file | Excel Discussion (Misc queries) | |||
| Automatically have even numbered rows shaded gray? | Charts and Charting in Excel | |||
| Writing a Macro that will Plus Cells | Excel Programming | |||
Threaded Mode
