Fill cell based on # of days

  • Thread starter Thread starter spezticle
  • Start date Start date
S

spezticle

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 :)
 
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 :)
Click to expand...

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.
 
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
 
Hmm, it should work, unless I've misunderstood something. I tried it
before posting and it worked. You do have to change the reference in
the formula to the first cell, which sounds like it is actually B2 in
your file.

But maybe you just want those exact cells in each sheet colored. This
will work as long as it is always the same cell on each sheet.

Group your sheets using SHIFT-Click or CTRL-Click on the tabs. Go to
the cells you want, color them, and it will do every sheet. Ungroup by
right-clicking on a tab and select Ungroup.
 
Back
Top