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 https://www.youtube.com/watch?v=8iotSp2lNtc 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]
- Thank you again for your assistance.
Just a followup question. =IF(L3<>"", TODAY(), ""), what if I wanted to add M3 coulm along with L3? This way when "Either L or M" columns are filled with a name, then the date will still populate (which would now be Column N).
This is my personal account when working from home btw.Shipwreck818 If you want today's date to appear when either cell L3 or M3 is filled out, you can use the following formula:
=IF(OR(L3<>"", M3<>""), TODAY(), "")Optional tip if this was helpful: [link removed by admin]
- Thank you so much for your assistance. This works perfect, thank you!
- Thats amazing, you made a video so perfect to what I was hoping for. When get home later tonight I will be tipping on PP. Thank you so much!
