Is there a way I can use a formula like COUNTIF to scan a large spreadsheet to return the number of occurrences of a value say 'XY' where the cell colour is also highlighted in Yellow ? At the same time, ignoring all the occurences where the cell isn't highlighted ?

Any help would be gratefully received.

Tdub