Whenever I try to change the colour of the border of cells or an area in Mac Excel 2011 i get an error: "Font size must between 1 and 409" and cannot change the colour of the border.
The only easy way is to change the font size of all the cells to the same size, which is not convenient at all as sometimes the font has different font sizes and it wants to have one font size.
I have found a way which is very difficult and frustrating but you select Format Cell - Font.
Clicking through with the tab button - Font - Font Style - Size (as there is no size selected due to different sizes). IF you select the size it changes all the font to that one size which has to be undone. Then I undo it and then go back to format cell and and click through it again and say OK. Sometimes it takes a few "undo's" and doing it again before I can change the colour of the selected area or cells.
This is really not ideal and a HUGE bug in the Excel system but at least now I can move pass it.
If someone has a better way of doing this please let me know.
Thanks
The only easy way is to change the font size of all the cells to the same size, which is not convenient at all as sometimes the font has different font sizes and it wants to have one font size.
I have found a way which is very difficult and frustrating but you select Format Cell - Font.
Clicking through with the tab button - Font - Font Style - Size (as there is no size selected due to different sizes). IF you select the size it changes all the font to that one size which has to be undone. Then I undo it and then go back to format cell and and click through it again and say OK. Sometimes it takes a few "undo's" and doing it again before I can change the colour of the selected area or cells.
This is really not ideal and a HUGE bug in the Excel system but at least now I can move pass it.
If someone has a better way of doing this please let me know.
Thanks