SOLVED

Multiple Arguments - Conditional Formatting

%3CLINGO-SUB%20id%3D%22lingo-sub-1302284%22%20slang%3D%22en-US%22%3EMultiple%20Arguments%20-%20Conditional%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1302284%22%20slang%3D%22en-US%22%3E%3CP%3EI%20want%20to%20compare%20dates%20in%202%20columns.%26nbsp%3B%3C%2FP%3E%3CP%3EColumn%20A%20%3D%20Due%20Date%3C%2FP%3E%3CP%3EColumn%20B%20%3D%20Completion%20Date%3C%2FP%3E%3CP%3EColumn%20C%20%3D%20Conditional%20Formatting%20based%20on%20comparison%20of%20A%20and%20B.%3C%2FP%3E%3CP%3EResults%20wanted%3A%3C%2FP%3E%3CUL%3E%3CLI%3ECompleted%20on%20time%20(green%20fill)%3C%2FLI%3E%3CLI%3ENo%20completion%20date%2C%20but%20due%20date%20greater%20than%20today%20(no%20fill)%3C%2FLI%3E%3CLI%3ENot%20completed%20on%20time%20(red%20fill)%3C%2FLI%3E%3CLI%3ENo%20completion%20date%2C%20but%20due%20date%20less%20than%20today%20(red%20fill)%3C%2FLI%3E%3C%2FUL%3E%3CP%3EThanks%20in%20advance.%3C%2FP%3E%3CP%3EShawn%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1302284%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1302709%22%20slang%3D%22en-US%22%3ERe%3A%20Multiple%20Arguments%20-%20Conditional%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1302709%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F619160%22%20target%3D%22_blank%22%3E%40Shawn0463%3C%2FA%3E%26nbsp%3BPerhaps%20like%20this%20(picture%20taken%20on%20a%20Mac.%20Similar%20for%20PC%20though).%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202020-04-13%20at%2016.37.02.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F183946iA446FCD853D904CF%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Screenshot%202020-04-13%20at%2016.37.02.png%22%20alt%3D%22Screenshot%202020-04-13%20at%2016.37.02.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EFile%20attached%20with%20a%20working%20example.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1302777%22%20slang%3D%22en-US%22%3ERe%3A%20Multiple%20Arguments%20-%20Conditional%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1302777%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3BThat%20did%20the%20trick.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20very%20much.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1302800%22%20slang%3D%22en-US%22%3ERe%3A%20Multiple%20Arguments%20-%20Conditional%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1302800%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F619160%22%20target%3D%22_blank%22%3E%40Shawn0463%3C%2FA%3E%26nbsp%3BGlad%20it%20worked!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
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
Highlighted
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.

Highlighted

@Riny_van_Eekelen That did the trick.

 

Thank you very much. 

Highlighted

@Shawn0463 Glad it worked!