I want to build a search function into my spreadsheet. Because my data is formatted in a way such that Excel filter will not work (won't filter by columns), I am using data validation and conditional formatting to highlight and sort.
My spreadsheet currently has 3 lists data validation fields with the options "Yes" and "No". Each of the 3 fields is compared to different cells that will determine the highlighting according to
K2, L2, and M2 are my 3 data validation fields and D35, D63, and D82 are what's being compared with the data validation to determine highlighting.
This currently works, but I must pick "Yes" or "No" for all the data validation fields and it will highlight the cell only if it has the exact the combination of choices.
How can I make this so I don't have to pick a choice for all data validation fields. For example if I choose "Yes" for the first 2 fields and leave the third blank or something, it will only highlight based on what I've selected only.
Bookmarks