VBA to convert a coloured matrix into an equivalent matrix of 1's and 0's

Hi,

I have a coloured matrix that I'd like to convert into an equivalent matrix of 1's and 0's (example attached).

NB - If it makes a difference the same colour is always used to populate the matrix.

Thanks in advance,

Snook

Something like this?

Please Login or Register  to view this content.

Exactly what I was after!

Cheers CK76!

Hi

You can also do it directly using the UI,

1 - fill the cells with 0
2 - use Ctrl-H and use replace using the format of one of the coloured cells.
3 - remove the colour