If I understand you correctly, you are looking to "green-light" employees who have been working for you for six months or more, with the current "today" date being the reference point.

The attached sample spreadsheet will do that, if the hire dates for the employees are in the same column.

You will want to look in "Conditional Formatting" to see how this works.

tanstaafl.