Re: IP Address Spreadsheet That Auto Highlights Duplicates
*Whoops, just read it's OpenOffice. It still might be the same. For future reference, this is how you do it in Excel.
Click on a column then go to Conditional Formatting > Highlighting Cells Rules > Duplicate Values
Then you can change the specifics. When a duplicate value shows up, like an IP written exactly the same, the box will be highlighted in red or red text or however you want it. I only do this for one column and am not sure how to do it for the full spreadsheet or what have you, but I'm very sure it's possible.
|