Conditional Formatting to work on rows like they do on columns

Richard

Hi

Is it possible to set conditional formatting on rows like it is for columns, or is there a workaround?

Thanks

Cheers

Richard

Shaine Greenwood

Hi Richard,

For my own edification, how are you wanting a row specific conditional formatting rule to work? Would you want specific rows to be set as the conditional formatting rules?

"If x conditions are met then apply this format to rows 1-30."

Or are you wanting a different functionality?

Richard

If a cell has a value less than zero, turn background red. To apply to a row of cells.  It's a row that is the result of the rows above being row1 - row2 = row3. It is row3 that I need to apply this conditional formatting to. Thanks

Shaine Greenwood

You can define custom criteria to set your rule to turn the entire row background red when a cell in a specific column is less than zero. More info on this in the Conditional Formatting help article.

I attached a screenshot of how this rule looks in my sheet using a column titled Effort.

Let me know if you have any questions or this wasn't what you were looking for.

 

Richard

Hi - Sorry, it was just to turn that particular cell red that had gone minus, not the entire row. it was to apply to all cells in that row. Thanks

Shaine Greenwood

Ah, now I see what you're saying.

This type of functionality can be achieved with multiple conditional formatting rules—one for each cell in the column that you want to have turn red.

Create one rule that will apply format only to a specific column (not the entire row) and then clone the rule. Change the column that the formatting is applied to—rinse and repeat until you have a rule for each of your columns.

Richard

Indeed, but I have 50+ columns  to apply to and I don't particularly want the rule applied to other cells in the columns. I'm thinking that what you say is my only option? Thanks