I am perplexed and confused. Having recently moved from Excel 2003 to Excel 2010 I am having a learning curve to ride again ... but that aside, I have a problem I cannot resolve ...
I have a group of cells with data validation rules to allow only a Y or N as the cell values. The normal cell background is light yellow and I use conditional formatting to change the background to light pink if the cell value = Y, thereby displaying yellow cells for N and pink cells for Y. In Excel 2010, when the result of conditional formatting is True (ie., cell = Y), the background turns pink but the cell alignment changes from center aligned to left aligned. There is nothing I can do stop that from occurring. Has anyone seen this situation? Is there a solution to maintain the cell alignment and stop it from becoming left aligned?
Thanks,
Steve
I have a group of cells with data validation rules to allow only a Y or N as the cell values. The normal cell background is light yellow and I use conditional formatting to change the background to light pink if the cell value = Y, thereby displaying yellow cells for N and pink cells for Y. In Excel 2010, when the result of conditional formatting is True (ie., cell = Y), the background turns pink but the cell alignment changes from center aligned to left aligned. There is nothing I can do stop that from occurring. Has anyone seen this situation? Is there a solution to maintain the cell alignment and stop it from becoming left aligned?
Thanks,
Steve