Ask Your Question
0

How to put conditional formatting on styles only, NOT numbers [closed]

asked 2014-02-26 00:30:34 +0100

Neeol gravatar image

updated 2016-02-19 15:03:48 +0100

Alex Kemp gravatar image

I put some conditional formatting in a Calc (v4.1.2.3 on OS X) table to change the row background color when a specific column in that row is not blank. Unfortunately, LibreOffice won't let me JUST set a background color - it INSISTS on also formatting numbers. So, if I set 2 of my columns that have fractional numbers to show only 2 digits past the decimal, I also end up with my column of whole numbers displayed with ".00" after the number. Friggin' brilliant - give the guy that thought THAT up a gold star.

Is there any way to set up conditional formatting so that ONLY my cell background, and maybe the font are changed, not every friggin' thing about the cell, and leave the rest of the cell formatting alone?????

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 2016-02-19 15:04:02.400486

1 Answer

Sort by » oldest newest most voted
0

answered 2014-02-26 01:41:54 +0100

w_whalley gravatar image

You need two cell styles; one with two decimals and the other with your other option. Create the styles independently based on the default style. When I first tried this I created one style based on the default style then created the other style based on the first style that I had created and ran into the same problem of coupled numbers of decimal places.

edit flag offensive delete link more

Question Tools

1 follower

Stats

Asked: 2014-02-26 00:30:34 +0100

Seen: 168 times

Last updated: Feb 26 '14