Conditional Formatting at Sheet Level - not row/column specific

Admin@PAT

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! 

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

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

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