Howdy all,

I need to create a spreadsheet that has columns where an X or a date can be entered and when the proper mark has been made inside that cell it will change a "status" cell to a different color. Once all of the columns have been properly marked the status cell changes to a final color.

Basically My spreadsheet is a work tracker. We need to be able to open the spread sheet and quickly see what has been done on a proposal and what still needs to be done.

not sure if I should be using conditional formating, or IF function, or a Macros... help please

our office is using both office 2013 and 2016 at this time.