Forum Discussion
Conditional formatting for multiple cells with a corresponding columns
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 ex...
What if you clcik on the existing rule in your first column and expand the range to all your other columns? Normally the formula should adpt then.
- Whoops! Sorry I see what you mean. That worked! Thanks so much!
- The problem is, it's still picking up the original rule of just looking at B2:B6. I was hoping the header will only look at the corresponding column. For example, Header 2 will only look at column C, Header 3 column D...etc. Sorry I can try attach an illustration but not quite sure how to do that.
