Conditional formatting & number alignment

[Klaas Vaak]

Assume:
a cell with a number, center aligned
apply conditional format (CF) to the cell
If the condition is fulfilled, the CF will change the alignment to right aligned. This might not be visible immediately, but after saving, closing, reopening the file, the number is right aligned. When you check the formatting of the cell (CTRL+1), Alignment tab, you will notice the alignment is still right. But it is impossible to get Excel to display the number in the center.
Is this a bug (my impression) or is there a way to correct this?

 

[Joe4]

Welcome to the Board!

I am not sure I understand. If there is Conditional Formatting that is Right Aligning the entry, you will not be able to override that and make the entry Center Aligned unless you remove the Conditional Formatting rule that is Right Aligning it. That is expected behavior. Conditional Formatting trumps anything manual.

If this is not what you are talking about, please explain in more detail and layout an exact example, complete with the value in the cell and what your Conditional Formatting conditions/formulas are.

 

[Klaas Vaak]

Thanks for your reply. CF was not put in there to right align the number - I don't even know if that would be possible.
No, before CF the cell has a number (value) in it, and the cell is formatted to center align the number. That works fine.
Then I apply CF to turn the number & background to red & pink respectively when the number rises above a threshold value. When that value does go above the threshold, the colours change. I save the file. Then when I reopen the file the number is aligned to the right, even though the format dialogue (CTRL+1), Alignment tab, still shows the alignment of the cell to be aligned to the right. There is no way to get Excel to display the cell contents (i.e. the number) center aligned.