multiple condition lookup and match cell format
I was able to get the VBA code from Ozgrid.com and I'm happy to say it did
the job.
"CJ at home" wrote:
Sheet 1: A 35 cell column, each with user intials "XXX", each cell is
formatted with font and pattern choices.
Sheet 2: Cells A1:M15. If the contents of a cell matches one of the cells
in Sheet 1, match the contents and the format of that cell.
Can't use conditions, because there are only three. I'm hoping I just don't
get arrays yet.
|