Forum Discussion
James818
Dec 07, 2023Brass Contributor
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...
- Dec 07, 2023
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
Brass Contributor
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
Dec 07, 2023Brass Contributor
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!