Hi, i have a worksheet, one sheet (“Tracker”) has a row in column E with numbers that i would like to match in a seperate sheet called “Palletainer Lookup” whereby anything that matches any numbers from the Palletainer Lookup sheet in column A is highlighted in purple on the tracker sheet in column E. 

i have looked at various posts and i believe its around the conditional formatting but i cannot fathom the correct formula ! 

​Hi, i have a worksheet, one sheet (“Tracker”) has a row in column E with numbers that i would like to match in a seperate sheet called “Palletainer Lookup” whereby anything that matches any numbers from the Palletainer Lookup sheet in column A is highlighted in purple on the tracker sheet in column E.  i have looked at various posts and i believe its around the conditional formatting but i cannot fathom the correct formula !     Read More

​