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
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.
Thanks!
Comments
-
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!
-
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.
OR
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?
Craig
-
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
