Hello all!
I have a spreadsheet with named ranges. These are Day1, Day2, Day3... and so on.
What I would like to do is this: When the user opens the excel spreadsheet I want only the current Day range (I.e Day21 = 1/21/04) to be white. I would like all of the other Day ranges to be grey.
I imagine this will involve some VBA.
I would appreciate any help in this matter.
----------------------------------------
Buddha. Dharma. Sangha.
I have a spreadsheet with named ranges. These are Day1, Day2, Day3... and so on.
What I would like to do is this: When the user opens the excel spreadsheet I want only the current Day range (I.e Day21 = 1/21/04) to be white. I would like all of the other Day ranges to be grey.
I imagine this will involve some VBA.
I would appreciate any help in this matter.
----------------------------------------
Buddha. Dharma. Sangha.