Good afternoon
I have been looking on the net to use conditional formatting Cant seem to find the right guide
I am trying to get Column A to look up its self the truck number and match it to Column j and M and going on the cell next to it the colour would change
Green for PIK Red for REL
I have tried to use =$N3="PIK" which was working Then I remember some times we have a truck that is not on the list so we add it in e.g. Truck 14A Truck3A in Column A
which then bugs out =$N3="PIK" and it changes some of the colours
I think I need to use a vlookup or a Match
Any help would be great
Bookmarks