I have a spreadsheet that I would like to apply some conditional formatting to but not sure were to start. I would for a green check mark to appear in column a when the following columns have the word complete, yes, N/A and a date that is not expired. I would like a yellow exclamation point to appear when the year of the date is the current year. I would like a red X to appear if a cell is blank, the date is expired, has no, incomplete, or in progress. I have attached part of my spreadsheet. Then columns I want to use to determine what flag appears are in column F through column T. Can anyone help with this?