Thank for the reply.
Is there a way to get that cell to color with no text/data in that cell?

Please see attached.
Thank you!

example.xlsx