Traffic Light Weekly Report.....

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.

Hi Shane,

A tiny sample is attached ...

HTH
Carim

Hi Carim,

Thanks for the file.

Did you use a formula or????

I cannot see how you colour coded the cells in the example that you provided.

Thanks,

Shane.

Hi Shane,

Formulas are located in Format Conditional Formatting ...

If you want use the same principle without having numbers in your cells, the easiest would be for you to upload a zipped copy of your worksheet for a tailor-made answer ...

HTH
Carim

Hi,

I have attached an example.

Please advise if this does not make sense.

Thanks much,

Shane.

Hi,

Is there a fixed number of rows ...in your report ...?

Carim

The number of rows is fixed.

Ok then ...

So what would be precisely the range ... ?

Carim

Attached is the worksheet you sent with conditional formatting ...

HTH
Carim