Hello everyone. Thank you for reading and helping if you are.
I need to accomplish the following I have used a conditional formatting formula =$E1=$A$1. that uses search box in A1 to look for words in column and then highlights the entire row that word is in. In this case it is aircraft registrations.
if I don't have something written in the search box in A1 the selected area is highlighted that does not have any data in.
Can someone please help me to have my formula ignore all blank areas when there is nothing written in A1
Bookmarks