Start with # in COL A, search COL B
if found, take corresponding number in COL C and search COL D
if both found, change background in cond. formatting (FOR COLUMN E....)
Attached sample.
Can't figure out how to code it.
Start with # in COL A, search COL B
if found, take corresponding number in COL C and search COL D
if both found, change background in cond. formatting (FOR COLUMN E....)
Attached sample.
Can't figure out how to code it.
Last edited by x65140; 02-06-2014 at 05:16 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks