Recent content by Jes.persona

  1. J

    How do I write the code for <If cell is empty return "text"> in conditional

    formatting in MS Excel? I need the conditional formatting code for <If cell is empty return "text">. I will use text, and possibly symbols (such as arrows). If it is not possible, please reply and tell me so. The reason I want to use conditional formatting rather than just overwriting the empty...
  2. J

    What is the "IF" formula for searching for a certain letter or symbol in a cell?

    (MS Excel)? I've got a list of several thousand names. Names of people and names of companies. Each time a company is used, a specific symbol is added to show that it's a company. This symbol is sometimes before, and sometimes after the company name. I.e. the cell may or may not begin with this...
Back
Top