Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
colour coding alternate weeks
I am entering dates every week into a spreadsheet. How can I
automatically colour a date on week 1 as red and week 2 as green for all alternate weeks? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
colour coding alternate weeks
You can use Conditional Formatting to do this. See
http://www.cpearson.com/excel/banding.aspx for instructions and sample formulas. This goes beyond simple alternating rows -- you can create bands of multiple rows with alternating colors. Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group Pearson Software Consulting, LLC www.cpearson.com (email on web site) On Sun, 19 Jul 2009 07:18:53 -0700 (PDT), Lynn wrote: I am entering dates every week into a spreadsheet. How can I automatically colour a date on week 1 as red and week 2 as green for all alternate weeks? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
colour coding alternate weeks
the colour coding should not be based on rows. it should be based on
the date entered. eg. if date entered was within week1 of month1 it should be green, if date entered was within week3 of month4, it should be yellow, etc..etc.. any idea? On Jul 19, 11:47*pm, Chip Pearson wrote: You can use Conditional Formatting to do this. Seehttp://www.cpearson.com/excel/banding.aspxfor instructions and sample formulas. *This goes beyond simple alternating rows -- you can create bands of multiple rows with alternating colors. Cordially, Chip Pearson Microsoft Most Valuable Professional * * Excel Product Group Pearson Software Consulting, LLCwww.cpearson.com (email on web site) On Sun, 19 Jul 2009 07:18:53 -0700 (PDT), Lynn wrote: I am entering *dates every week into a spreadsheet. How can I automatically colour a date on week 1 as red and week 2 as green for all alternate weeks?- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Colour coding data | Excel Discussion (Misc queries) | |||
Counting and colour coding ranges of occurances | New Users to Excel | |||
Automatic Colour Coding on a Row | Excel Discussion (Misc queries) | |||
Conditional formatting: Colour coding | Excel Discussion (Misc queries) | |||
colour alternate rows in filtered list | Excel Programming |