I’m putting data into cells, down a column.
What I want to do is this…
If I enter the same data in any cell in that column, that’s already in another cell in that column, get a warning.
Example:
12345
34567
32459
65679
76456
12345.…this cell or next cell in row goes orange because this data is already in cell 1
Excel Formula Question (solved)
Sounds like you want a VBA macro that runs any time data is entered into excel.
The macro would create a long comma delimited string containing all the values in the column
The macro would then run an instr() function on the string using the current input as an argument
The return value of the function would then cause the current cell to change background color
Probably 5-6 lines of VBA.
The macro would create a long comma delimited string containing all the values in the column
The macro would then run an instr() function on the string using the current input as an argument
The return value of the function would then cause the current cell to change background color
Probably 5-6 lines of VBA.
I haven't lost my mind, it's backed up on disk somewhere.