Conditional Formatting Plus a Variable from another Column

For whatever reason the SOW has the dates listed as month/year and you're suppose to just know that it's on the last day of the month... I guess I'll have to go through and update the dates so they reflect the month/day/year format.

With that said, please forgive my excel ignorance, which of the many formulas in your workbook should I use?

You guys have some very impressive Excel knowledge. I'm struggling just to understand them even after you all have constructed them lol.

-Pred





Pred

Format the date as month / day / year (mm/dd/yyy) and use formula in post No. 2

This will work

Thanks

Regards