Hi All,

I have a single column of data that is, perhaps, 100 rows long.

I have ticks, crosses and 'N/A' in various cells within this column. There are no cells that are blank.

I want to count the number of ticks within the column and want to be able to say:

If the number of ticks is = 100% then it's green.
If the number is >75% and <100% then it's amber.
If the number <75% then it's red.

I also want to exclude the N/A cells from the % calculation.

Any help is greatly appreciated.

Thanks,

Shane.