View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
John John is offline
external usenet poster
 
Posts: 2,069
Default 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