Conditional Formatting icons if user forgets to fill in the date

Viewed 20

Good day! I need guidance on how to display the icons (conditional formatting), when user forgets to fill in the date. enter image description here

The condition is:

  • If the term starts with 'D' and the direction is import, then date ETA, ATD, and ATA must be filled.

  • If the direction is export, then date of ATA and Actual delivery date must be filled.

  • If the direction is Domestic and mode is 'ROA', then date of ATD and ATA must be filled.

Expected outcome: enter image description here

Appreciated any help provided.

Attached pbix: https://drive.google.com/file/d/1QtPNtqjQIevB38guOU57ZT3f679ueK3z/view?usp=sharing

Thank you!

0 Answers
Related