Forum Discussion
Conditional Formatting is not working properly
| 85 | Setting Ring(8mm) | Mitutoyo | GTS-120 | 100803 | 20/01/2023 | 19/01/2024 | GCLC/68857.10/2023 | Expired |
| 86 | Setting Ring(6mm) | Mitutoyo | GTS-121 | 100370 | 20/01/2023 | 19/01/2024 | GCLC/68857.11/2023 | Expired |
| 87 | ** Hardness Block(30.2 HRC & HLD 543) | Mitutoyo | GTS-122 | EP10127545 | 30-11-2010 | 29/11/2015 | 176140 & 176139 | Expired |
| 88 | ** Hardness Block(34.2 HRC) | Mitutoyo | GTS-123 | EP10120026 | 25-01-2010 | 24-01-2015 | 165025 | |
| 89 | ** Hardness Block(63.1 HRC) | Mitutoyo | GTS-124 | EP10127456 | 26-11-2010 | 25-11-2015 | 176010 | |
| 90 | ** Hardness Block ( 91.0 HRB(S) | Mitutoyo | GTS-125 | EP10127524 | 30-11-2010 | 29-11-2015 | 176101 | |
|
Please refer to the picture above attached.
2 Replies
What you would like to highlight instead of these 3 dates?
- i want to check expired instruments.
I put the conditional formatting formula "Duplicate"
In this cell the formula is not working properly.
