That's fine. If you do that, and write your formula as it pertains to the first cell in your column, Excel will automatically adjust it for all the other rows in your column.
I highlighted the column, clicked on conditional formatting and pasted this in the conditional format but there are still dates that are not highlighted suc as 5/5/2015 & 5/8/2015?: =weeknum(A1)=weeknum(today())
I apologize if these are basic questions, but let's confirm these things first:
- Are you dates entered as dates or text?
- Is your first date in cell A1?
- Did you remember to select a Formatting Option (I am embarrassed to say, I actually forgot to do that once)?
All right. Pick any blank cell and enter this formula: =WEEKNUM(A7)
Then pick another cell and enter this formula: =WEEKNUM(TODAY())
Then try: =WEEKNUM(A7)=WEEKNUM(TODAY()) that last one should return TRUE.
If not, make sure that your formula matches your range reference.
Make sure that you are NOT highlighting the whole column, but starting with cell A7.
Or else your formula and cell references will not be aligned.
I figured it out - the best way to do this in Excel 2010 is to select column, select Conditional Formatting at top, select Highlight Cell Rules, select "A Date Occcuring" - This week is one of the options.
Cool. Never really checked those out (usually just write them myself), but that certainly does make things easier.
The method I proposed should still work though (I tested it out for myself to confirm that before posting).
Something must have been "off kilter".
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.