A
Asoka Walpitagama - Brandix College IT
A B C
DATE 1 Supplier DATE 2
12-Nov BTT 10-Nov
12-Nov BCT 11-Nov
13-Nov BTT 12-Nov
11-Nov BLL 13-Nov
11-Nov BCT 4-Nov
16-Nov BTT 12-Nov
In the above list I need to format DATE1 ( A) when SUPPLIER (B)="BTT" AND
DATE1-DATE2 ( A-C)>3 USING CONDITIONAL FORMATTING
Should highlight the 1st & 3rd rows of data
DATE 1 Supplier DATE 2
12-Nov BTT 10-Nov
12-Nov BCT 11-Nov
13-Nov BTT 12-Nov
11-Nov BLL 13-Nov
11-Nov BCT 4-Nov
16-Nov BTT 12-Nov
In the above list I need to format DATE1 ( A) when SUPPLIER (B)="BTT" AND
DATE1-DATE2 ( A-C)>3 USING CONDITIONAL FORMATTING
Should highlight the 1st & 3rd rows of data