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]
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!
