Hi everyone,
I'm trying to use the search formula in a conditional formatted cell. I current have this formula:
=SEARCH(search_box,$C$8:$O$587)
Search_box is where I input the data that I want to search for and after the , is the data range which is just a table. I have also formatted this to highlight the row green.
When I input data into the search box, nothing highlights and when there is nothing in the search box, the entire table is highlighted green.
If someone could please assist me on this matter as I'm going insane haha
Thanks,
Dan
I'm trying to use the search formula in a conditional formatted cell. I current have this formula:
=SEARCH(search_box,$C$8:$O$587)
Search_box is where I input the data that I want to search for and after the , is the data range which is just a table. I have also formatted this to highlight the row green.
When I input data into the search box, nothing highlights and when there is nothing in the search box, the entire table is highlighted green.
If someone could please assist me on this matter as I'm going insane haha
Thanks,
Dan