I have a spreadsheet with some cells black and some red. Im trying to programatically tell the difference in a macro, but cells(x,y).Font.Color is equal to 0 for all cells whether red or black. Is there another prop to look at?

Thanks in advance for any help!