|
|
#1
11-21-2019, 04:07 AM
|
|||
|
|||
Conditional Formatting
Hi
I want to start formatting on the first short date in the column and repeat each 5th day see example * dates marked yellow background 08-Nov* 09-Nov 10-Nov 11-Nov 12-Nov 13-Nov* 14-Nov 15-Nov 16-Nov 17-Nov 18-Nov* 19-Nov 20-Nov 21-Nov 22-Nov 23-Nov* If I use the following formula the return is partly correct but I cannot get it to start on the nominated date Code:
=MOD(B1,5)= 1 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Conditional Formatting | chrisoconn | Excel | 0 | 07-05-2017 02:10 AM |
 Is Conditional Formatting Possible?
|
Wocky | Project | 1 | 01-16-2017 05:39 PM |
|
Conditional formatting that ignores other formatting rules
|
info_guy2 | Excel | 1 | 07-03-2014 10:07 AM |
| Conditional formatting | zanat0s | Excel | 4 | 01-20-2012 03:30 AM |
| Conditional Formatting | namedujour | Excel | 3 | 08-25-2011 01:46 PM |
Windows 10 
Office 2010
Threaded Mode