Calendar

Hello from Steved

I've built my self a twelve month calendar 4 months across by 3 months down

This Calendar Starts from The month Off February to January the followin year.

Ok This is my issue
Feb 6, Apr 14, Apr 17, Jun 5, Oct 23, Dec 25, Dec 26, Jan 1, Jan 2 all
public holidays
Like to shade it Green

from Apr 18 to 21, Apr 24 to 28, Jul 3 to 7, Jul 10 to 14, Sep 25 to 29,
Oct 2 to 6, Dec 15, Dec 18 to 22, Dec 27 to 29, Jan 3 to 5, Jan 8 to 12,
Jan 15 to 19, Jan 22 to 26, Jan 29 to 31.
Like to shade it Blue

Feb 25, Mar 25, Apr 22, May 27, Jun 24, Jul 22, Aug 26, Sep 23, Oct 28,
Nov 25, Dec 23 Jan 27 are the end of the financial periods each are 28 days
Like to shade it Red

Yes I know about Conditional formatting but iy only allows 7 cells
Has anyone built a calendar and in VBA allow a particular date to be
nentered and you can change tthat cell to blue, for example the date is Jan
15 it wiil change the cell to blue.

Thankyou.

This is one of the few instances in which manual is better than VBA.
Manually set one cell to blue. Then select all the other cells you want to
make blue and do a control-y.

Repeat with the other colors.
--
Gary''s Student


"Steved" wrote:

> Hello from Steved
>
> I've built my self a twelve month calendar 4 months across by 3 months down
>
> This Calendar Starts from The month Off February to January the followin year.
>
> Ok This is my issue
> Feb 6, Apr 14, Apr 17, Jun 5, Oct 23, Dec 25, Dec 26, Jan 1, Jan 2 all
> public holidays
> Like to shade it Green
>
> from Apr 18 to 21, Apr 24 to 28, Jul 3 to 7, Jul 10 to 14, Sep 25 to 29,
> Oct 2 to 6, Dec 15, Dec 18 to 22, Dec 27 to 29, Jan 3 to 5, Jan 8 to 12,
> Jan 15 to 19, Jan 22 to 26, Jan 29 to 31.
> Like to shade it Blue
>
> Feb 25, Mar 25, Apr 22, May 27, Jun 24, Jul 22, Aug 26, Sep 23, Oct 28,
> Nov 25, Dec 23 Jan 27 are the end of the financial periods each are 28 days
> Like to shade it Red
>
> Yes I know about Conditional formatting but iy only allows 7 cells
> Has anyone built a calendar and in VBA allow a particular date to be
> nentered and you can change tthat cell to blue, for example the date is Jan
> 15 it wiil change the cell to blue.
>
> Thankyou.
>
>
>
>
>