Ask Your Question
0

Conditional Formatting affecting cell category

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

Prolink gravatar image

Hello

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
0

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

pierre-yves samyn gravatar image

Hi

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:

screenshot

Regards

edit flag offensive delete link more
0

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

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
0

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

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

Stats

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

Seen: 101 times

Last updated: Jun 30 '15