Formatting cells according to arrays

M

Mickey

I want to create arrays out of columns (One array for each column) and
format cells in the whole workbook according to these arrays.
Meaning, whatever is in array 1 will have format x; whatever is in
array 2 will have format y and so on.
I also want to clear the format of any cell that its content is not in
any of the arrays

Can anyone help me? I new to this…
 
F

Frank Kabel

Hi
if you only have 3 arrays you may take a look at conditional format and
enter a formula like
=COUNTIF(array1,your_cell)>0
 
Top