Please forgive what may be a stupid question, but the issue description was unclear...
When you say that 'the font color changes back to black when you click another cell,' was the next cell that you click in previously formated for a the different font color?
So, in other words, you highlight a column or row, change the font color to red with that row or column still highlighted and then later click within that previously formated column or row and the font changes back to black?
The reason I ask this is because the normal behavior of the cells in an Excel spreadsheet is to default to the system's default font style and color (black) unless the cells properties are previously changed.
You can select individual cells for formatting by using the CTRL+click combo and you can format all the cells in an entire spreadsheet by clicking in the very upper right hand corner box to highlight the whole sheet.