Forum Discussion
Conditional Formatting Highlighting Rows Based on another cell
James818 You want to apply conditional formatting based on a custom formula. This is the formula to use:
=$N3<>""I made a custom video showing how I came up with the formula and how to correctly apply it: https://www.youtube.com/watch?v=8iotSp2lNtc
Optional tip if this was helpful: [link removed by admin]
James818 You want to apply conditional formatting based on a custom formula. This is the formula to use:
=$N3<>""
I made a custom video showing how I came up with the formula and how to correctly apply it: https://www.youtube.com/watch?v=8iotSp2lNtc
Optional tip if this was helpful: [link removed by admin]
LouisDeconinck I’ve tried multiple times to follow your excellent instructions, but I can’t get it to work. I’m missing something.
I want the entire row of my table to highlight once a date has been entered in column G. As long as there is no date in that column, I want the row to stay unfilled.
I manually coloured the first row in my example, but I’m sure there’s a better and easier way. Can you please help?
Jewles813 My earlier video instructions should also apply here. You want to use conditional formatting based on a formula. In your case the formula would look like:
=$G2<>""You need to use G2 as that is the cell of the first row you want to check. Notice how there's a $ in front of the G, but not the 2. That's very important. It allows the conditional formatting to be shifted downwards.
Make sure that the conditional formatting is applied to your entire table, so from A2:G1000
Optional tip if this was helpful: [link removed by admin]
