94mustang
Board Regular
- Joined
- Dec 13, 2011
- Messages
- 133
- Office Version
- 365
- 2019
- Platform
- Windows
Hello Excel Experts,
See the uploaded images of my spreadsheet attached this thread. I am wanting to highlight the cell that occurs every 4 years from the Cert Date (Col B) or a start date. The Display (cell B4) will change the dates in the grey header cells from Monthly to Quarterly. The idea is to have the cell in that row to be highlighted in January or the First quarter every 4th year in the future. In my screenshot, I have a custom formula for conditional formatting that is highlighting every January, but I am needing it to be every 4th year.
I also upload a screenshot with Display changed to Quarterly and the current formula is working but again the highlighted cell needs to be the first quarter every 4th year.
Likewise, the Surv Date (Col D) occurs every 6 months. I would like a formula that will do this for me as well. Based on any solutions that will resolve my dilemma, I may be able to apply it to the Surv Date for every 6th month in the future.
Any help or advice would be greatly appreciated. Thank you
See the uploaded images of my spreadsheet attached this thread. I am wanting to highlight the cell that occurs every 4 years from the Cert Date (Col B) or a start date. The Display (cell B4) will change the dates in the grey header cells from Monthly to Quarterly. The idea is to have the cell in that row to be highlighted in January or the First quarter every 4th year in the future. In my screenshot, I have a custom formula for conditional formatting that is highlighting every January, but I am needing it to be every 4th year.
I also upload a screenshot with Display changed to Quarterly and the current formula is working but again the highlighted cell needs to be the first quarter every 4th year.
Likewise, the Surv Date (Col D) occurs every 6 months. I would like a formula that will do this for me as well. Based on any solutions that will resolve my dilemma, I may be able to apply it to the Surv Date for every 6th month in the future.
Any help or advice would be greatly appreciated. Thank you