I'm putting together a new spreadsheet for my team where I'm tracking "batches" and their approval through the system. The spreadsheet will list 200+ batches per month and each batch has a different due date. I would like to apply conditional formatting where when I populate the date completed, it will highlight it in green if its earlier or equal to the due date, and in red if its later than the due date. I've tried everything I can think of and can only get it to work on one row. When I try to copy it down it doesn't work.
Thanks