Ask Your Question

Can "Conditional Formatting" be made to work in xlsx format?

asked 2016-12-30 19:36:18 +0200

Lew Merrick gravatar image

I am creating a spreadsheet that, because of the "interface" to other software, must operate in xlsx format. It appears that none of the "Styles and Formatting" that I create for my "Conditional Formats" are accessible when saved in xlsx format. Am I missing something?

Irrational minds want to know...

edit retag flag offensive close merge delete


LO version ? Version of Excel or whatever the other program is ?

rautamiekka gravatar imagerautamiekka ( 2016-12-30 20:17:27 +0200 )edit

I have Excel 2016 x64 on same Win7 as LO x64, XLSX made in either software worked fine on both.

rautamiekka gravatar imagerautamiekka ( 2016-12-30 20:28:44 +0200 )edit

I am running LO B5.1.6.2 and when I Save As xlsx format, my "defined condition" disappears. I do not have Excel and have no clue what version of that would be used. I preferLibre Office in all things -- but I have to live in the MS Office universe...

Lew Merrick gravatar imageLew Merrick ( 2017-01-01 16:55:10 +0200 )edit

B as in Beta ?? Wtf are you doing with such an ancient version ?

rautamiekka gravatar imagerautamiekka ( 2017-01-01 18:02:19 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2017-01-23 13:32:11 +0200

I made the following test with LO on Windows 10 x64:

  1. Created a new spreadsheet.
  2. Selected A1:C3 -> Format -> Conditional Formatting -> Condition...
  3. Cell value is equal to 0 -> Apply Style -> New Style...
  4. Organizer -> Name - blue; Font Effects -> Color -> blue
  5. Save as XLSX
  6. Open with MS Excel (I used 2016) -> enter 0 or 1 to A1 or any other in the range

The test shows that conditional formatting applies OK. The color changes depending on entered value. The same is with newer versions, including current master. So, either you have some problem with your installation, or there's some specific details you need to provide.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-12-30 19:36:18 +0200

Seen: 293 times

Last updated: Jan 23 '17