Excel Cell and Font Color VBA If statement
https://vbatutorialcode.com/excel-cel...
This video uses .font.colorindex and .interior.colorindex to assign font colors and cell colors to cells with VBA. You can use If statements with the colors for more customization. I also like to use Select Case statements with this for really complicated programs.