Ask Your Question

Conditional Formatting affecting cell category

asked 2015-06-29 14:48:56 +0200

Prolink gravatar image


I have an xls file with conditional formatting which highlights a row of cells when the value of one of those cells is "Open".

The conditional formatting works in as much as it highlights the row, but for some reason it removes the existing cell categories from that row. So, for example, dates cells are not being displayed in a date format. If I try to change the category back to date nothing happens.

Is this because it's an xls file? Or something else I'm missing?

Thanks Scott

edit retag flag offensive close merge delete

3 Answers

Sort by » oldest newest most voted

answered 2015-06-30 11:25:43 +0200

pierre-yves samyn gravatar image


In other words, you can use just one cell style for different contents if this style does not overload formats compared to the default style. You can verify in the Organizer Tab:



edit flag offensive delete link more

answered 2015-06-30 02:26:32 +0200

m.a.riosv gravatar image

If the number format for the style applied with the conditional format is different than the Number-Standard, you need to do a different conditional format for the columns with dates.

edit flag offensive delete link more

answered 2015-08-04 15:33:26 +0200

Prolink gravatar image

Thanks for your help. It must have just been a problem with that particular file (probably because it was an xls file) because I wasn't doing anything wrong but it just wouldn't format correctly for me.

I copied all the contents to a new spreadsheet and it is working now.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2015-06-29 14:48:56 +0200

Seen: 113 times

Last updated: Jun 30 '15