Using conditional formatting to change the number format
I would like to use conditional formatting to change the number format. I have created a Style that includes the number format I want. The conditional formatting only seems to take on the colour and not the number format. Is there a way to get conditional formatting to change the number format? Any help appreciated.