How do i create a Macro that would color certain cells based on a pattern?

**BADebbie** · 09-30-2015, 02:52 PM

I'm trying to duplicate this calendar for 2016. Is there a macro or something I can create to populate each month with the correct color pattern? Here is the pattern

4 YW
6 GR
4 YW
4 GR
6 YW
4 GR

Crew Schedule.jpg

**Toonies** · 10-01-2015, 03:10 AM

hi have a look at this it may help you

http://chandoo.org/wp/2011/08/01/shi...xcel-template/

How do i create a Macro that would color certain cells based on a pattern?

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

How do i create a Macro that would color certain cells based on a pattern?

Re: How do i create a Macro that would color certain cells based on a pattern?

Thread Information

Users Browsing this Thread

Similar Threads

Macro to insert pattern based on value and select based on pattern

[SOLVED] Lookup and return rows based on pattern start and pattern end

Delete cells based on pattern

Create new reference number based on pattern.

create macro in excel to protect cells which has no color format?

Count of cells with Color (Pattern)?

How do I change color pattern based upon a formula within a cell?

Bookmarks

Bookmarks

Posting Permissions