Ask Your Question

Can't change font color on autoformatted spreadsheet [closed]

asked 2013-02-08 21:35:44 +0200

Edward gravatar image

updated 2015-10-17 15:36:30 +0200

Alex Kemp gravatar image

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?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-17 15:36:58.041109


@jorendc -- another one for you :-)

qubit gravatar imagequbit ( 2013-03-10 04:11:32 +0200 )edit

@Edward: 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. <br> Thanks in advance<br>Joren

jorendc gravatar imagejorendc ( 2013-03-14 13:03:35 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2013-11-12 15:50:48 +0200

Jim7fl gravatar image

updated 2013-11-12 15:52:10 +0200

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

edit flag offensive delete link more

Question Tools


Asked: 2013-02-08 21:35:44 +0200

Seen: 2,268 times

Last updated: Nov 12 '13