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