Hello, community! Still new on Excel, please help me make command formulations. I have a continuing input of 3 digit cell data of any combination from 0 to 9 having 31 rows and now at ff culumn data. Need to make command formulation as I need to search 6 sets of cell data and to highlight with 6 color each identified cell which contains 3 digits in any order.
Say, command lookup 123 red, 445 green, 067 yellow, 376 orange, 888 blue, 945 violet. so I could easily see all datas color shaded...Can anyone provide the formulation of commands?
Thanks
