Conditional formatting with Colour

Hi Anni

Thanks for clarifying.

I think you could only count based on the formatting of a cell if you did some VBA coding.

You can however count the number of times a word appears within a range, so if you had unavailable and available (or even U and A for short), you can use COUNTIF to count how many times each appears; then you could divide this by the total number of days to get a percentage.

Then you could apply conditional formatting to colour in addition if you wanted (e.g. if cell contains U, formatting is green; if cell contains A, formatting is red).

I have attached an example for you of how this could work. I hope this helps.

Amanda