|
|
#1
06-06-2012, 09:19 AM
|
|||
|
|||
Conditional Formatting per Week
I'm working with a table separated per month on each sheet. There is a column for date and I would like to conditionally format every other week to easily identify them.
The catch: our working week is not Sunday - Saturday, it is Thursday - Wednesday. How would this be possible?  I've search and found a formula for every other row, but would like every 7 rows based on Thursday - Wednesday. ( =MOD(ROW(),2)=1 ) 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| conditional formatting | otuatail | Excel | 1 | 06-06-2012 05:07 AM |
 Conditional Formatting.
|
Laurie B. | Excel | 6 | 04-09-2012 05:01 PM |
|
Conditional formatting with AND, OR
|
Lucky | Excel | 2 | 10-03-2011 11:41 PM |
|
Conditional Formatting
|
namedujour | Excel | 3 | 08-25-2011 01:46 PM |
|
help with conditional formatting
|
Snvlsfoal | Excel | 3 | 07-03-2011 11:55 PM |
Windows XP 
Office 2010 32bit
Threaded Mode