click on the cell, from the menu bar- Format / Conditional formatting

"Sher" wrote:

I have an End Date of my spreadsheet of projects. If the project wasn't
completed on time I would like box to turn red. Is there a way to do that?
If so, please help.