Nov 25 2021 01:54 PM
in four blank cells, i entered 1200 in the cell A1, i entered -8000 in the second cell A2, i entered 0 in the third cell A3 and i entered the text Hello There! in the cell A4.
Then i selected all four cells as a range. I open the format cells dialog box by pressing ctrl+1, and i selected the Number tab and number in the category list. Whereupon i click the #,##0_);[Red](#,##0) code in the custom Category Type list box, and then i edited as follows: [Blue]#,##0_);[Red](#,##0);[Green];[Cyan]. And then i clicked OK. But it appaered me the following message (see the screenshot). How can i fix this
Nov 25 2021 02:18 PM
What do you see when you open the attached workbook?
Nov 26 2021 02:41 AM
Nov 26 2021 03:04 AM
Just copy/paste format string which @Hans Vogelaar suggested from his file. Typing manually perhaps you shall use semicolons instead of commas, depends on your regional settings.
Nov 26 2021 08:43 AM
Nov 26 2021 09:02 AM
Select the cell.
Press Ctrl+1.
If necessary, activate the Number tab.
Select the custom format string in the Type box, and copy it (Ctrl+C).
Do the same in your own workbook, but paste (Ctrl+V) instead of copy.