On Sep 11, 11:00*am, Gord wrote:
What do you mean by *"X'd out"?

Post an example.

Gord Dibben * *MicrosoftExcelMVP

On Sat, 10 Sep 2011 20:00:47 -0700 (PDT), jt
wrote:



i wish to count cells in a range that havediagonalcellbordersor
the cell is X'd out, is it possible, thanks for any help- Hide quoted text -

- Show quoted text -

excellent, this works, thankyou