My issue is similar but with a twist. if i have a range of cells A1 - A10, one of which will contain the number '1' , what code do i need to write so that if another '1' is put elsewhere in the...