MATCH in Conditional Formatting

[JTL9161]

Hopefully I can explain this enough for someone to answer.

I have a column (30+ rows) that I labeled "LIST" I then on another worksheet have a Conditional Format formula saying =MATCH($AJ60, LIST,0)

The LIST column is all blank lines until a condition is met then it will fill with either UNDER or OVER. If the LIST column fills for example with UNDER the CF does highlight all the UNDER's on the worksheet and the OVER's are blanked out or removed but although the fields are now blank except for a formula =""&VLOOKUP($AG62,'Over-Under'!$G$261:$L$406,4,FALSE) the blank field still highlights the same as with the cells with UNDER. How do I make the MATCH formula ignore the opposite of what is on the LIST.


Thank you,
James

 

[SanjayGMusafir]

Just now I seemingly answered a similar question here. See if this is what you are looking for and revert.

Highlighting overwritten cells - conditional formatting

Hi all, We share an excel template with our network for them to input quarterly monitoring data with us. Some fields we attempt to restrict through drop down lists. These often get overwritten. So my question is whether we can use a tool to show the user that they've overwritten a dropdown...

www.mrexcel.com

 

[Peter_SSs]

@JTL9161
Any chance that you could provide some sample data with XL2BB and explain again in relation to that specific sample data?