If you need to get the format for a cell, it would be
Cells (1,1). Font.colorindex
Load variable with the row that you wish to test, then place it back on the current row.
If you wish to test font size, it is
I hope this is what you are asking.