Forum Discussion
Solved
Conditional Formatting Highlighting Rows Based on another cell
Hello Excel community. I am creating an inventory log for work; were we list clients for our clerical unit to process fax. mail and so on. MY hope was to include Conditional formatting, dar...
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]
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.
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!
