If you use conditional formatting you can highlight the contents of the equivalent in column M
It applies the filled range in column M
In column N place the following formula:![]()
$L4=$I$4
See attached sample![]()
=IF($I$4=$L4,M4,"")
If you use conditional formatting you can highlight the contents of the equivalent in column M
It applies the filled range in column M
In column N place the following formula:![]()
$L4=$I$4
See attached sample![]()
=IF($I$4=$L4,M4,"")
---
Hans
"IT" Always crosses your path!
May the (vba) code be with you... if it isn't; start debugging!
If you like my answer, Click the * below to say thank-you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks