Can't change font color on autoformatted spreadsheet

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?

@jorendc – another one for you :slight_smile:

@Edward3: Custom autoformat = conditional formatting? In that case you can go to Format > Conditional formatting > Manage… or Conditions. If I understand it wrong, please feel free to attach the document so we can have a look.
Thanks in advance
Joren

I don’t know if this will accomplish what you wish, but scroll down to my answer on this link:

I do not know specifically how you “auto formatted” your rows, but this is my technique. This, of course contains info on how to change the background, but your named style could also have font info.

Best Regards,

Jim Smith