I have been fighting this for days and can't find the solution. I am trying to compare two date columns. If the date comes before the other column it will show green. If it comes after that other column then it will show yellow. I am basically comparing two different column dates and depending on where the date falls it formats the background accordingly. Can someone please help? This determines whether or not I use this as a tool. So far, I can only get it to show a single color no matter the date in the column I am comparing it to.
In the example shown I am trying to compare the right column to the left. If it comes before or the same day to the left column then it should be green. If it is after, then yellow. Left column [Tech Package Draft Target] Right column [Tech Package Draft Actual].