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
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.
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:
Regards
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.
