Question on excel conditional formatting?

Question

I formatted a set of rows and columns to display text in different colors based on the text entered. Now when I try to open it in OpenOffice the conditional formatting on the cells does not show up since its not supported. Instead is there a way I can remove the conditional formatting but keep the color scheme intact?

Update:

I'm using Excel 2007

Strider · Accepted Answer

I think there is no way you can retain the colors if OpenOffice can't read it...

The way you can do it is by just putting the colors not by conditional formatting.

-OR-

Repeating again what you did in excel (Conditional Fomatting in Open Office)

http://openoffice.blogs.com/openoffice/2007/01/conditional_for.html

Both are long cut by the way

mathieu · Answer

Did .xls files support conditional formatting? If not, that might be an intermediate step you could use.

Also, what happens if you export to OpenOffice.org format, in Excel? I think Excel 2007 supports this. (Looks: yep.

http://office.microsoft.com/en-us/excel-help/file-formats-that-are-supported-in-excel-HP010014103.aspx#BMdatabaseformats)

Trending News

Question on excel conditional formatting?

2 Answers