Forum Discussion
How to carry conditional formatting down from row to row
Maybe, it's hard to say without seeing the file or at least screenshots. Please check sample file attached, it works.
One more question, please SergeiBaklan. I would like to again format a column based on another column. When I put a date paid in the other column, I want to highlight my cell to trigger for follow up. Once I put in a yes or n/a in my current cell, I want the highlighting turn turn off. I've tried a number of combinations using If/And combinations with Null/Blank/>0, but nothing I've tried so far is working. Here's my current formula. I'm sure it's something simple to fix it, but I can't quite figure it out. Any help is appreciated!
="IFS($S$3ismm/dd/yy,$V$3Is("yes"OR"n/a"))"
Thanks, SergeiBaklan. Here's my formula: =($S$3>1)*($V$3<>"yes")*($V$3<>"n/a"). This one isn't working this time. Any other ideas? 🙂
If we speak not about only one cell but about the columns, you need to unlock rows references in formula, i.e.
=($S3>1)*($V3<>"yes")*($V3<>"n/a")And we assume your range to which conditional formatting is applied, starts from third row and not from any other one.
Yes, SergeiBaklan,it starts at the third row since I have headers. I have the Applies To set at =$V:$V. Is there something else I should change? Thank you so much.