RAJESH1960
Banned for repeated rules violations
- Joined
- Mar 26, 2020
- Messages
- 2,313
- Office Version
- 2019
- Platform
- Windows
Hello guys,
I need some help in conditional formatting formula with multiple conditions. I am trying to find out which Invoice number are not matching in column E. If the date is same in cell F2 and F3, and in the As per column one is Portal and one is Tally then the invoice number should be the same in column E. If they are not the same with the above 2 conditions I want to color the cells E2 and E3 and so on...
IF B2<>3, F2=F3, THEN CHECK IF E2=E3,IF NOT TRUE COLOR E2&E3
In short, I want to color the column E cells if date is same, if as per column one is portal and one is tally & if the numbers in column E are different.
I need some help in conditional formatting formula with multiple conditions. I am trying to find out which Invoice number are not matching in column E. If the date is same in cell F2 and F3, and in the As per column one is Portal and one is Tally then the invoice number should be the same in column E. If they are not the same with the above 2 conditions I want to color the cells E2 and E3 and so on...
IF B2<>3, F2=F3, THEN CHECK IF E2=E3,IF NOT TRUE COLOR E2&E3
In short, I want to color the column E cells if date is same, if as per column one is portal and one is tally & if the numbers in column E are different.
QUERY TO MATCH INVOICE NO..xlsx | ||||||||
---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | |||
1 | Line | As Per | Invoice number | Invoice Date | ||||
2 | 1 | PORTAL | 20210731 | 28-08-2020 | ||||
3 | 2 | TALLY | 20210731 | 28-08-2020 | ||||
4 | 3 | PORTAL | 093A/2020-21 | 08-09-2020 | ||||
5 | 4 | PORTAL | S3/0019/2020-21 | 16-06-2020 | ||||
6 | 5 | TALLY | 19 | 16-06-2020 | ||||
7 | 6 | PORTAL | S3/0115/2020-21 | 19-11-2020 | ||||
8 | 7 | TALLY | S3/0115/2020-21 | 19-11-2020 | ||||
9 | 8 | PORTAL | 1562/20-21 | 01-02-2021 | ||||
10 | 9 | TALLY | 1562 | 01-03-2021 | ||||
11 | 10 | TALLY | 4396 | 19-01-2021 | ||||
12 | 11 | PORTAL | 390/20-21 | 20-07-2020 | ||||
13 | 12 | TALLY | 390 | 20-07-2020 | ||||
14 | 13 | PORTAL | 1262/20-21 | 22-12-2020 | ||||
15 | 14 | TALLY | 1262/20-21 | 22-12-2020 | ||||
16 | 15 | PORTAL | 1955/20-21 | 29-03-2021 | ||||
17 | 16 | TALLY | 1955 | 29-03-2021 | ||||
18 | 17 | TALLY | 1210 | 10-12-2020 | ||||
19 | 18 | PORTAL | 1210/20-21 | 10-12-2020 | ||||
20 | 19 | PORTAL | 1561/20-21 | 01-02-2021 | ||||
21 | 20 | TALLY | 1561/20-21 | 01-03-2021 | ||||
22 | 21 | TALLY | 1099 | 01-07-2020 | ||||
23 | 22 | PORTAL | 781/20-21 | 24-09-2020 | ||||
24 | 23 | TALLY | 781/20-21 | 24-09-2020 | ||||
25 | 24 | TALLY | 4107 | 12-10-2020 | ||||
26 | 25 | PORTAL | 1481/20-21 | 20-01-2021 | ||||
27 | 26 | TALLY | 1481/20-21 | 20-01-2021 | ||||
28 | 27 | TALLY | 109 | 03-06-2020 | ||||
29 | 28 | PORTAL | 109/20-21 | 03-06-2020 | ||||
30 | 29 | PORTAL | 1042/20-21 | 13-11-2020 | ||||
31 | 30 | TALLY | 1042 | 13-11-2020 | ||||
32 | 31 | PORTAL | 934/20-21 | 21-10-2020 | ||||
33 | 32 | TALLY | 934/20-21 | 21-10-2020 | ||||
34 | 33 | PORTAL | 1244/20-21 | 17-12-2020 | ||||
35 | 34 | TALLY | 1244/20-21 | 17-12-2020 | ||||
36 | 35 | PORTAL | 143/20-21 | 06-06-2020 | ||||
37 | 36 | TALLY | 143/20-21 | 06-06-2020 | ||||
38 | 37 | PORTAL | 780/20-21 | 24-09-2020 | ||||
39 | 38 | TALLY | 780 | 24-09-2020 | ||||
40 | 39 | PORTAL | 940/20-21 | 22-10-2020 | ||||
41 | 40 | TALLY | 940/20-21 | 22-10-2020 | ||||
42 | 41 | PORTAL | 389/20-21 | 20-07-2020 | ||||
43 | 42 | TALLY | 389 | 20-07-2020 | ||||
44 | 43 | TALLY | 1389 | 05-01-2021 | ||||
45 | 44 | PORTAL | 170/20-21 | 11-06-2020 | ||||
46 | 45 | TALLY | 170 | 11-06-2020 | ||||
47 | 46 | PORTAL | 630/20-21 | 01-09-2020 | ||||
48 | 47 | TALLY | 630 | 01-09-2020 | ||||
49 | 48 | PORTAL | 746/20-21 | 17-09-2020 | ||||
50 | 49 | TALLY | 746 | 17-09-2020 | ||||
B2B + Tally Original (2) |