Hi there. I have a sheet with so many rows and columns, and I want to set a condition where if some specific fields are not blank, then that field will be highlighted. I managed to do that, but it seems like i can only set one column at a time. Is there a way to set that condition throughout the entire sheet, not just having to set for each column separately?
Help Article Resources
Check out the Formula Handbook template!