detweiler
Board Regular
- Joined
- Aug 2, 2013
- Messages
- 60
Hope my ask actually makes sense...
I would like to have a macro that would compare the values in a column, let's say column J, to a fixed list or an array written in the macro, and then highlight the cell or change the text color of the value that doesn't match what's in the list?
Any suggestions on how to set this up are appreciated.
I would like to have a macro that would compare the values in a column, let's say column J, to a fixed list or an array written in the macro, and then highlight the cell or change the text color of the value that doesn't match what's in the list?
Any suggestions on how to set this up are appreciated.