Forum Discussion
Solved
How to carry conditional formatting down from row to row
I am trying to format a column based on the conditional formatting in another column. I have Year Built in column I. When a cell in column I is less than 1978, it highlights the cell pink. Now...
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"))"