clarksonneo
01-29-2011, 10:43 AM
Hi,
I need a macro which can produce the result like the picture below.
For all numbers I selected,
if the number appears at the first time (eg cell A3), the cell colour will be green,
if the number appears more than 1 time (eg cell A4, A5), the cell colour will be yellow.
How can I achieve it?
Thanks
I need a macro which can produce the result like the picture below.
For all numbers I selected,
if the number appears at the first time (eg cell A3), the cell colour will be green,
if the number appears more than 1 time (eg cell A4, A5), the cell colour will be yellow.
How can I achieve it?
Thanks