Hi

I'm using Excel 2003 and have a range of cells whose colour is
determined by conditional formatting.

Does anyone please know if there is a way to count the cells in this
range which have a particular colour - say yellow?

I have a feeling I tried this before but could only find a solution
which worked if the cell colour was from ordinary (manual) formatting
rather than conditional formatting.

Many thanks.