Despite trying countless ideas, ranging from deleting the conditional formatting function and redoing it, changing the formatting type of the cells, using the "Clear All" command on these particular two cells and doing everything from scratch, But that could not be the case since I have initially already anticipated such a problem and formatted the whole column as Scientific formatting the cells) automatically.
Some reason, Excel decided that 01E018 and 10E017 are the same thing and highlighted the both cells.Īt first I was expecting that Excel was converting the values in these cells into numbers (i.e. However, in particularly one instance, as shown in the image, for
#Openoffice conditional formatting cells with duplicate data serial number#
LOT serial number for each production batch so I used conditional formatting in order to make sure I do not use the same LOT serial number in two different production batches.įor almost a year, I had practically zero problems with using conditional formatting function in order to highlight the duplicate cell values and thus alert me. That being said, I have a column to store that
I use Excel to store and analyze production data from a company, and as you may know, products batch numbers (LOT serial numbers) should not be repeated and used in different batches. I'm using Microsoft Office Professional Plus 2019, and I have this file that I use constantly on a daily basis.