SOLVED

Multiple Arguments - Conditional Formatting

New Contributor

I want to compare dates in 2 columns. 

Column A = Due Date

Column B = Completion Date

Column C = Conditional Formatting based on comparison of A and B.

Results wanted:

  • Completed on time (green fill)
  • No completion date, but due date greater than today (no fill)
  • Not completed on time (red fill)
  • No completion date, but due date less than today (red fill)

Thanks in advance.

Shawn

3 Replies
best response confirmed by Shawn0463 (New Contributor)
Solution

@Shawn0463 Perhaps like this (picture taken on a Mac. Similar for PC though).

Screenshot 2020-04-13 at 16.37.02.png

File attached with a working example.

@Riny_van_Eekelen That did the trick.

 

Thank you very much. 

@Shawn0463 Glad it worked!