Ask Your Question

Can't change font color on autoformatted spreadsheet

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

Edward gravatar image

updated 2013-10-10 23:14:52 +0200

manj_k 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 close merge delete


@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

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
Login/Signup to Answer

Question Tools


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

Seen: 899 times

Last updated: Nov 12 '13