I have columns A6 - F6. Column A6-A56 contains the days date. I want the cell color to change to yellow after each day passes. For example on 9/26 I want all the cell colors for 9/25 to change colors. I retired and don't use excel much and have forgotten a lot. Your help is appreciated.