Forum Discussion
Jucysterfry
Sep 27, 2020Copper Contributor
I see a colon or semicolon when I "hide" cell contents
I'm building a calendar template. In a few cases, I have a logic function in a cell to indicate what background color to use in conditional formatting. The function returns a 1,2,3, or 4 depending on...
SergeiBaklan
Sep 28, 2020Diamond Contributor
Is that like this what you do?
And do you see semicolons only when print or on screen as well?
- JucysterfrySep 29, 2020Copper Contributor
I just checked, and discovered, I had used three colons ":::" instead of three semicolons ";;;" in the "Custom" Category "Type" field, in the "Format Cells" dialog box. I can see the difference now.
Thank you-
- SergeiBaklanSep 29, 2020Diamond Contributor
Thanks for the update, glad to know you sorted this out