First time here? Check out the FAQ!
Hi, I'm trying to give conditional formatting to a column in LibreOffice Calc containing time values. I have selected the column format as Time format(HH:MM:SS) Now when I try conditional formatting on this column, for e.g, to highlight all fields with time greater than 09:30, all the fields get highlighted, except the blank cells in between.
Related image: I was unable to upload a picture here, so I have uploaded at imagebin.org The url is: http://imagebin.org/211074
answered 2012-05-05 11:03:00 +0200Pedro
You probably typed 9:30 in the condition field. While Excel is clever enough to accept 9:30 (and then converts it to number in the background), Calc doesn't.
(You can check in Excel that if you return to the Conditional Formatting dialog instead of 9:30 there is 0.395833333333333)
You have two options: type the actual value (in this case 0.395833333333333) or point to a cell which contains your condition in time format i.e. just have a cell somewhere in the spreadsheet or on another sheet with 9:30
In addition you can add this as a request for an enhancement in
LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!
Asked: 2012-05-05 08:53:57 +0200
Seen: 408 times
Last updated: May 05 '12