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.

Resources