Conditional Formatting and Advanced Filter

[niha]

Hi Guys,
I'm using advance filter to get certain locations based on an ID. As soon as I click search, I get the locations. I want these location (eg: from 10 -30) get highlighted/colored in the map beside. Currently I have just used conditional formatting's "between" function as it can be 30-10 sometimes too, how can I use it in a macro to get the cells colored? Also, there can be multiple rows that the adv filter searches. Please help!

 

[Marc L]

Hi,​

​

as an advanced filter works only with a smart worksheet respecting Excel basics rules like an unique header for each column, …​

​

 

[niha]

Hi,​

​

as an advanced filter works only with a smart worksheet respecting Excel basics rules like an unique header for each column, …​

​

The adv filter is working fine. I just want to highlight the searched values in the map. How do I do that? Eg: If the range is 30-50, I want cells from 30-50 to get highlighted in the map.