Oct 26 2023 11:30 AM
Hi all,
I was wondering if anyone can help with a conditional formatting. I'm trying to apply conditional formatting for the header (row 1) if the value of the column is greater than zero. For example below, it would only highlight Header 4 cell because in total it adds up to 0. I used the formula ("sum(B1:B6)>0") successfully but it didn't copy paste well on the other columns. I also tried removing the $ sign as well but that didn't work. Unfortunately I'm dealing with dozens of columns, so wondering if there's a quick formula/rule to do this?
Header 1 | Header 2 | Header 3 | Header 4 | Header 5 | |
Max | 1 | 1 | 1 | ||
Bob | 1 | 1 | |||
Ingrid | 1 | 1 | |||
Maxine | 1 | ||||
Simon | 1 | 1 |
Thanks in advance!
Oct 26 2023 11:36 AM
Oct 26 2023 11:43 AM
Oct 26 2023 11:56 AM