colour coding alternate weeks

L

Lynn

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?
 
C

Chip Pearson

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)
 
L

Lynn

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to automate update on weekly reports spreadsheet 0
Display weeks from a Milestone 0
Resource name inside resource sheet: per person, work per hours per week 0
Is it possible to edit colours already saved as part of a custom theme? 0
colour coding alternate weeks 10
Show week number in Project Report 0
Subtracting two cell dates and highlight if over due by a certain amount of days 0
Integrating information from Word to Excel (not mail merge) 1

Top