Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

asked 2012-05-05 08:53:57 +0200

saji89 gravatar image saji89 flag of India

http://saji89.wordpress.c...

Unable to do conditional formmating on tcolumns containing time values

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

click to hide/show revision 2
Corrected typo in title.

Unable to do conditional formmating formatting on tcolumns columns containing time values

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