Conditional Formatting

Options

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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!