Conditional Formatting

[ctglass]

I am using Excel 2010 and am having trouble using conditional formatting to create a right border on a collumn of cells based on the relationship between todays date and a date in a specific cell. I am essentially trying to create a vertical line that moves from collumn to collumn based on the current date. I am trying to use conditional formatting to create a right border for the collumn of cells that fits todays current date. Here is the formula I am using but it isn't working. Any help would be greatly appretiated.

if(today()<=$J$49)

cell J49 is where my date is located, however I will probbably need to have a greater than and a less than clause, and again this is being entered into the conditional formatting wizard

[ChemistB]

It sounds like you are applying this to a range of cells, let's say J49:Z100. You can't have the cell reference anchored with $ as it needs to be relative.

=TODAY()<= J49
Does that work for you?

[ctglass]

J49 is the cell that has the date I am comparing today's date to. I am then trying to apply the formatting (the right border) to a collumn of cells

[ctglass]

I need all the help I can get on this issue... let me know what other information I can supply or if i need to clarify anything... thanks for the help!

[NBVC]

today()<=$J$49 will format all the cells that you select if today's date is less than the date in J49.

How is Excel to determine the correct column to fomat? That is not clear.

Can you post a sample workbook showing what you expect to see... or expand your explanation a bit better.

[ctglass]

Unfortunatley the spreadsheet and data I am working with is confidential but I will do my best to better explain what I am trying to achieve. I am creating essentially a project management template, with a list of tasks in the far left collumn (vertical); with a series of weeks (week 1, week 2, week 3, etc) in a lower row (horizontal). In the corresponding cells I will be placing check marks stating task 3 was completed in weeks 4 and 8 for example. I am now trying to use conditional formmatting to create a vertical line that moves depending on the current date (today function). I wanted to accomplish this by formatting the coresponding collumn with a right border as the vertical line. So i need a formula that i can use in the conditional formatting wizard that can compare todays date to the start dates for each week. So if today's date is in between the dates marking the start date for weeks 3 and 4, there would be a vertical border on the right side of the collumn for week 3.... let me know if that clarifys

[NBVC]

How are those weeks entered at the bottom? You need dates in order to compare to today's date.

[ctglass]

There are two cells above eachother. One with the start date for the coresponding week (date form, mm/dd) and the lower cell lists the name of the week (week 1, week 2, etc.)

[NBVC]

So assuming the tasks are in A2:A28 and the dates begin in B29 onwards ...

Then if you select from B2 to bottom right corner of the range in Row 28 to the right most column to consider, then apply conditional formatting with formula:

=AND(B$29<=TODAY(),B$29+7>=TODAY())

[ctglass]

Thanks a bunch NVBC!!! Rep added and issue solved