Conditional Formatting

Adam burbridge

Hi all,

I have a sheet which has approx 55 columns, with alot of different data on, i need to set up conditional formatting to colour a cell yellow if it contains "TBC".

I know i can set conditional formatting, but its a long and tedious task to do it per column. Is there a way that i can set up conditional formatting for the sheet as a whole?

Thanks in advance

Andrée Starå

Hi @Adam burbridge

I hope you're well and safe!

Unfortunately, it's not possible now, but it's an excellent idea!

Please submit this as a Product Feedback or Idea (If it hasn't been added already) when you have a moment.

I hope that helps!

Be safe and have a fantastic week!

Best,

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

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking 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!

davidharley

It's unbelievable that in 2023 smartsheet can't figure out how to add conditional formatting to more than a single column. Given the choice between creating 50 rules in smartsheet, or 1 rule in Excel to do the same thing, guess where all your customers are going?