# Calc - conditional formatting prob after update

I have just today upgraded from 5.1.6.2 to the latest version for windows - sorry don't have number as on another machine elsewhere atm.

I have a spreadsheet with extensive use of number formats as styles including N° of decimal places, e.g: formula is if value of C1=1 then apply 2 decimal places to 5 place number in target cell. All was working fine until I upgraded and now the decimal place change no longer works. I have messed around with this so much that I have just cleared out all direct and conditional formatting and started again from scratch (leaving the styles as they were)....now I can't reproduce the same result no matter the direct format of the target cell. Other aspects of the same style work fine such as cell background colour and font effect.

I have just now tried to get this to work on my machine with the 5.1.6.2 but with the same result.

So, my condition is C1=1 with the style to be applied as number of decimal places....I have tried changing the direct format from number to general with no decimal places to the max 5 but no joy.

I feel there must be something very basic that I'm missing but I can't see it.

EDIT: I have uploaded a sample as an attachment to my original question - which I hope will clarify things. To keep clutter to a minimum I have applied the conditional formatting to only the cells G3:G4 and H3:H4 using both a text cell and a number as examples of what isn't happening.

The specific result that I really want is that all numbers take the number of decimal places from column D where "FX" should result in a 5 decimal place number in the target cell and "IND" a two decimal place one. In my earlier functioning version, I was using 5 decimal places by default which were then modified by the condition Dx="IND" to a 2 decimal one.

I assume, there's no way to figure out your problem without having an anonymized example of your file (and conditional formatting). Please consider to upload a sample file ...