I have 2 sheets containing data. The first sheet is a "map" with bin locations and the second sheet contains a list of products and which bin they belong to, but the locations are separated into 4 columns.("Aisle", "Rack", "Level" and "Bay." Ideally I'd like to see if there's a way to use conditional formatting to highlight a cell on the 1st sheet if the 4 conditions for a location on the second sheet are met.
This is what I've tried so far that hasn't worked:
=countif((Inventory!$K:$K=6),(Inventory!$L:$L=31), (Inventory!$M:$M=1), (Inventory!$N:$N=61.1))
Solved by S. L. in 16 mins