jbrown021286
Board Regular
- Joined
- Mar 13, 2023
- Messages
- 81
- Office Version
- 365
- Platform
- Windows
i need to highlight certain cells with conditional formatting based of what day of the week it currently is. I need J1:J10 and V1:V10 highlighted on Monday, N1:N10 on Tuesday P1:P10 and L1:L10 on Wednesday, F1:F10 H1:H10 and R1:R10 on Friday. also if it is possible with just F1:F10 and H1:H10 I would like them to alternate which one is highlighted every other week (example H highlighted on 7/21/2023 and F Highlighted on 7/28/2023) once again only if it is possible. i do currently have a conditional formatting formula that effects all of the row 7 and row 10 cells in these colums and want this to new formula to take priority if there are any special steps i need to take.