Conditional formatting OR option

krrissti

Please create an OR option for conditional formatting. I have a list of 50 numbers, and I need to highlight if any of them exist in a specific cell. Without an OR option, I have to make 50 rules to accomplish this. Frustrating!

Andrée Starå

Please create an OR option for conditional formatting. I have a list of 50 numbers, and I need to highlight if any of them exist in a specific cell. Without an OR option, I have to make 50 rules to accomplish this. Frustrating!<\/p>","bodyRaw":"[{\"insert\":\"Please create an OR option for conditional formatting. I have a list of 50 numbers, and I need to highlight if any of them exist in a specific cell. Without an OR option, I have to make 50 rules to accomplish this. Frustrating! \\n\"}]","format":"rich","dateInserted":"2023-08-22T21:29:56+00:00","insertUser":{"userID":143398,"name":"krrissti","url":"https:\/\/community.smartsheet.com\/profile\/krrissti","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!!zdFYs7XV1Xo!8iNbN5Xj-7o!kB7AWH5TnAW","dateLastActive":"2023-08-22T21:25:26+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":true,"showPostLink":true,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/109309\/conditional-formatting-or-option","embedType":"quote","name":"Conditional formatting OR option"}"> https://community.smartsheet.com/discussion/109309/conditional-formatting-or-option

Hi,

I hope you're well and safe!

Here's a possible workaround or workarounds

• You could add a so-called helper column with a formula that checks for the different conditions. You'd then reference it in the Conditional Formatting rule.

Would that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå| Workflow Consultant / CEO @WORK BOLD

✅了我的帖子(s)帮助或回答你的问题吗tion or solve your problem? Please support the Community bymarking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!