If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Fill cell based on # of days
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 |
#2
|
|||
|
|||
Fill cell based on # of days
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. |
#3
|
|||
|
|||
Fill cell based on # of days
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. |
#4
|
|||
|
|||
Fill cell based on # of days
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. |
Thread Tools | |
Display Modes | |
|
|