kumara_faith
Well-known Member
- Joined
- Aug 19, 2006
- Messages
- 957
- Office Version
- 365
Hi,
I have the following table:
The dates in row 10 represents the start date for the particular week of the month. I would like only the current week in row 11 to be highlighted based on the current date.
Example: If the current date is Nov 14 2010, then only cell C11 should be highlighted.
Is there a formula I could use in conditional formatting ?
I have the following table:
| Excel Workbook | |||||||
|---|---|---|---|---|---|---|---|
| B | C | D | E | F | |||
| 9 | November 2010 | ||||||
| 10 | 01/11/2010 | 08/11/2010 | 15/11/2010 | 22/11/2010 | 29/11/2010 | ||
| 11 | WK1 | WK2 | WK3 | WK4 | WK5 | ||
Sheet3 | |||||||
The dates in row 10 represents the start date for the particular week of the month. I would like only the current week in row 11 to be highlighted based on the current date.
Example: If the current date is Nov 14 2010, then only cell C11 should be highlighted.
Is there a formula I could use in conditional formatting ?
