find match and replaced.
Hi,
anyone know how to find a # in columns F-I and match the # in columns A-C
then replaced that box to empty and fill in red color.
A B C F H I
-------------------------------------------------------
1 6 11 3 12 9
2 7
8 13
4 14
5 10 15
|