Forum Discussion
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 what I want to do is have column U create a trigger for me to follow up - on cells that are highlighted pink in column I. So if the year built is highlighted, I want the cell in the same row in column U to also be automatically highlighted.
I can do this row by row. For instance, I created a rule for cell U3 to be highlighted... =$I3<1978. However, I can't figure out how to carry that formatting rule down the rest of the column. It would be such a hassle to have to apply the rule to each individual row. I've tried adding to the rule created to cover the whole column, but it either deletes the highlighting rule in column I, or doesn't work at all.
And will this rule carry over if I upload it to Online? Help please. 🙂 Thank you!!
Maybe, it's hard to say without seeing the file or at least screenshots. Please check sample file attached, it works.
10 Replies
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"))"
- Awesome. That worked, thank you very much!
