Formatting cells according to arrays

  • Thread starter Thread starter Mickey
  • Start date Start date
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…
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Array Formula 1
Shape Arrays VBA 0
Conditional formatting rule precedence difficulties 3
Referencing a named array 1
Column number form an array 3
How to use vlookup in an array formula 2
array transpose for dynamic data without macros 7
Permutations andText to column problem 6

Back
Top