Forum Discussion

ituryu's avatar
ituryu
Brass Contributor
Jan 23, 2020
Solved

Predefined Text in Cells

Hi there. Does anyone know if it's possible to have predefined text in cells that only becomes visible after you type in it. For example I label a column as frame, and in every cell of that column, ...
excel
  • Wyn Hopkins's avatar
    Wyn Hopkins
    Jan 24, 2020

    No worries ituryu 

     

    Wyn

    MVP

    Australia UTC+ 8

     

    If this answer was the best response please click the button

    I also happily accept likes

ituryu's avatar
ituryu
Brass Contributor
Jan 24, 2020

Hi,Wyn Hopkins 

I am truly grateful, thanks a gazillion, it worked exactly.

 

Cheers.

Wyn Hopkins's avatar
Wyn Hopkins
MVP
Jan 24, 2020

No worries ituryu 

 

Wyn

MVP

Australia UTC+ 8

 

If this answer was the best response please click the button

I also happily accept likes

  • ituryu's avatar
    ituryu
    Brass Contributor
    Jan 25, 2020

    Hello,Wyn Hopkins 

    Thanks for the great pointer, but I seem to have developed an unexpected change and I'm not too sure what to do to rectify it. After using the custom "FRAME:" @ formatting, my sumifs function to help compute my weekly sales stopped working! I've tried inputting the custom format in the text reference but still not computing. So I'm guessing my syntax in wrong but not sure what next to do.

    =SUMIFS($G$4:$G$359,$A$4:$A$359,">="&AE25,$A$4:$A$359,"<="&AF25,$F$4:$F$359,$AJ$23&": *")

    Please help!!! That's the formula I used.

     

    Thank you.

    • Wyn Hopkins's avatar
      Wyn Hopkins
      MVP
      Jan 25, 2020
      Hi

      I can't really tell from just the formula, but at the end it references ": *" " if that is referring to the FRAME: GUCCI then it won't work since " : " is just part of the formatting not actually part of the result
      • ituryu's avatar
        ituryu
        Brass Contributor
        Jan 25, 2020

        Hi,Wyn Hopkins 

        Please what do you suggest that I do to get this resolved cause I've tried deleting it and also tried replacing as a text, but it isn't calculating!!!

         Any creative ideas from your noble end please?

Resources