Efficient Method to Loop for Multiple Conditions

Wondering if anyone has any advise on a more efficient method to loop through a range of cells (9, 20) to cells(307, 58), which is a graphical display of a calendar, find certain values and apply a condition to them. Essentially this is a dynamic calendar that tracks how long someone has been in a position in months and projects out graphically to Oct 2022. Each column from 20 to 58 is a month and each row from R9 to R301 is a position and name. The months in column 20 to 58 update automatically.

This function searches through the entire calendar section and looks for key dates and changes some formatting. It unmerges the cell and places some information below it. I.E. for 12 months it places "1 YR" beneath it and changes the 12 cell to fill black and changes the font color.

The code loops through each cell for each condition and I'm wondering if theres a method to check each cell for each condition then move on instead of checking for one condition per entire loop. I have attached the worksheet as well.

Please Login or Register  to view this content.