Can't change font color on autoformatted spreadsheet [closed]
I have a Calc sheet (app 30 rows, 70 columns, all formatted as text) containing ID#s. I enter new data in red, and use a custom autoformat to display alternating rows with a shaded background. I used to maintain this listing in Writer, but Calc makes it so much easier to add rows and columns, sort, and to print on X# of sheets.
I can't change the font color globally back to black (by selecting all the cells using my mouse or Edit/SelectAll and changing the font color); I'm still left with some cells showing red text. I can make my changes by selecting and then clearing direct formatting, but then I need to re-apply the the autoformat settings. Is there an easier way? Is there a way to search and replace FontColors, as there is in Writer?