tonyshortleighton
New Member
- Joined
- Mar 22, 2013
- Messages
- 6
I have a worksheet that has a a row dedicated to working dates. I would like to apply conditional format that highlights the first working date of the month. Due to weekends and bank-holidays it isn't as easy as simply identifying the 1st of each month. Any thoughts on how I could apply conditional format to achieve this?
<tbody>
</tbody>
Tue | Wed | Thu | Fri | Mon | Tue | Wed | Thu | Tue |
19/03/2013 | 20/03/2013 | 21/03/2013 | 22/03/2013 | 25/03/2013 | 26/03/2013 | 27/03/2013 | 28/03/2013 | 02/04/2013 |
<tbody>
</tbody>