Excel: cannot change alignment of a cell under conditional formatting

[freelensia]

Hi,

I have a structured table with a certain table style:

All of the cells in them are also formatted as "Normal". However my "Normal" is slightly different. It has cell background as white (not no-color), and has alignment OFF.

Furthermore, in column Good Listings I have some Conditional Formats. It is basically gray cell with white texts

As I know, cell alignment (left middle right) cannot be set with conditional formatting. So it was strange that the texts came out right-aligned (see first photo). More strange is the fact that I cannot reset this alignment via the alignment buttons in Home tab.

Anybody know why this is happening?

 

[jasonb75]

has alignment OFF.

Alignment OFF means that the content of the cell is positioned based on the number format used. Text aligns left, numbers align right, meaning that your conditionally formatted cells are normal and the orange cells are the ones that are actually misaligned.

The fact that you are unable to change the alignment on the home tab is unusual but I don't think that it will be possible to diagnose this with screen captures alone.
Noting a slight indent in one of the cells, which may or may not be of any help. Try checking BV4 for any spaces before or after the number 20. If the cell contains a formula, then you will need to trace back to the source of the data.

 

[freelensia]

Thank you. Turning Alignment ON in the Normal style solved this problem.
But it is still strange why I cannot manually set the alignment of the cells using the buttons in the Home menu.

 

[jasonb75]

That does seem unusual, but I don't think possible to diagnose without the file.