New Range Attribute / Property

[jcorlando]

Team,

Is it possible to create, via .xla, .com or some other method
a New attribute or property for a range or a cell?

E.g.: Worksheet("Sheet1").Range("A1").NewAttrib = 0

I need to test every cell that has data.
So I'm looking for some method to store if:
1) The cell has not yet been tested.
2) The cell has been tested and failed.
3) The cell has been tested and passed.

I was thinking of using the background color:
E.g:
The cell passed the test, then set: Cell().Interior.Color = RGB(255,255,250)
The cell failed the test, then set: Cell().Interior.Color = RGB(255,255,251)

This method worked. But ultimately, I'm wondering if it is possible
to just create a new attribute for all cells.

Any suggestions would be appreciated.

Giovanni,
In Annapolis, MD

 

[jcorlando]

Alternatively, Is there some unused or spare attribute
I could use for the same purpose??

Giovanni,
In Annapolis, MD