Nope, that didn't work.
Thanks for the catch on the date, by the way.

If this helps...
Sheet1-B1, then b33
then
sheet2-b1, then b33,
so on and so forth, will be the cells that will have the red highlight.

This is the goal of the sheet:
b1:J1 are headers either the date, "Averages", or "Totals"
a2:a16 are headers for start, finish,hours,tips,odom start,odom finish, etc
etc.
b2:j2 through b16:h16 contain all my data for work tracking of hours, tips,
gas, etc. everything related to work, money and mileage.

Payday is 9/17, and pay period ends 9/24.
all cells in pay period 1 of month 1 are green, with cell for pay day in
red. All cells containing a formula are in a darker green to notify me that i
shouldn't edit that cell
all cells in pay period 2 of month 1 are purple with cell for pay day in
red. All cells containing a formula are in a darker purple to nofity me that
i shouldn't edit that cell

month 2 repeats everything, but in 'sheet2', month 3 in 'sheet3', so on and
so forth. I have renamed 'sheet1' to 2008-09 and 'sheet2' to 2008-10, so on
and so forth.
1 Document per year, 12 sheets. per document. It's a really neat tips job
tracking log, and just shy of being perfected.

If there's an easy way to repeat the color scheme that i'm using for my
cells, it would be nice... if not... i can spend the extra time and manually
do 1 month, and copy it 12 times, then change necessary data.

But, if it's complicated, don't worry about it. I don't want ya spending all
that time messing around with my sheet.

Thanks,


Benjamin

"Spiky" wrote:

On Sep 18, 2:28 pm, spezticle
wrote:
My spreadsheet starts on the 17th of september. I'd like to have every cell
filled with red that =b1 (9/17/08) +14.
so,
9/17
10/1
10/14
10/28

all get highlighted. thanks :)

Try this in Conditional Formatting for all the possible cells, and
pick Red from the pattern formatting:
=MOD(B1-$B$1,14)=0

Note that 10/1 + 14days is not 10/14.