Conditional Formatting w/ criteria in a row vs a column
I have a grid with a row at the bottom that has either 100 or 0 in each column. I would like to create a conditional formatting rule that will highlight the column based on data in that single row. Conditional formatting rules look at criteria in columns rather than rows so I am wondering if anyone has come across the as a need and a solution.
Thank you in advance.