Condition
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?
Thank you
Answers
-
Hi Rodrigue,
Can you please take a screenshot of your conditional formatting window? It may help to be able to answer your question. Please block out any sensitive information.
Best,
Heather
-
You can have a condition apply to all the columns by creating your rule and select multiple columns (screenshot from one of my sheets):
However, what I think you are trying to do is the "opposite" where you want to select multiple columns for the condition. Unfortunately that is not possible. You will have to select each individual column to set the condition (IE has blanks or doesn't have blanks).
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 68K Get Help
- 474 Global Discussions
- 209 Use Cases
- 517 Announcements
- 5.6K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 85 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!