Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Conditional Formatting at Sheet Level - not row/column specific

edited 12/09/19 in Archived 2016 Posts

Hi there knowers of knowledge,


Is there a way to set conditional formatting so that across the sheet if the condition is met the format is applied.


Think: if sheet contains 'YES' apply this format, across the entire sheet.




  • Greg Gates
    Greg Gates ✭✭✭✭✭

    There technically isn't an option to do this in conditional formatting, but you could mimic the behavior. Let's say you have an individual cell somewhere where you type "YES" or "NO". I would then just add a column to your sheet, and set the value of every cell in this new column equal to the space where you typed "YES" or "NO." Now, feel free to hide the column.


    Back in conditional formatting, just apply your formatting based on the value of this hidden column to the entire row. Since every cell is the same, the formatting will be applied to your entire sheet.


    I hope that helps! Let me know if my explanation didn't make sense!

  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭

    I think either what Admin@PAT means is 


    if he types "Yes" in column [Bob's Stuff] or if he types "Yes" in column [Want Cheese?] or ....

    that the row is conditionally formatted.


    This could be handled by a formula in the new column Greg suggests - but would likely be a browser processing hog.




    if he types "Yes" in cell [Format Column]23 that the entire sheet is conditionally formatted.


    which I don't think anyone would want to do manually.


    Are you looking for the entire sheet (every cell) to be green if "Yes" one specific cell and blue if not?



  • Admin@PAT

    Thanks Gentlemen,


    Basically I'd like to highlight (by way of CF) any cell within the sheet based on a Value, whether it is a Name, text, number etc - I understand there will be options that are less inclined to be useful, such as dates, times or lengthy text fields.


    If 'YES' - apply Blue Fill - across whole Sheet

    * regardless of column, row, heading etc

This discussion has been closed.