cell shading
In xl2002+, you can use edit|replace to clear the cells that have a common
formatting.
If you're using an earlier version of excel, then I would use:
Select the cells that need to be cleared
Use Insert|Name|Insert (xl2003 menus) to create a name for this selected range.
Then whenever I wanted to clear that range, I could select the range (ctrl-g and
type the name) and then hit the delete key (on the keyboard).
dunny_budgie wrote:
Is there a way to automatically reset the value of all cells in a spreasheet
that have been shaded a specific colour?
In my spreadsheet I have (for ease of use) shaded yellow all the cells that
the user can input data into. Anything not shaded yellow is protected and
unavailable to the user. What i want to do is clear all the user inputs at
the end of each month, so that at the start of the following month they can
re-use the spreadsheet.
Can this be done? i could not find anything in VBA, but there must be
something.
Any help is appreciated!
--
Dave Peterson
|