partial content of a cell

I have a sheet that has cells with lots of text. I want to search the cell and see if the text exists. Below is the type of data I have. For reference, assume this is columns A and B and row 1(header) and 2 (text I need to search) I used Countif to search for "*active" in the range below and...

I want to change the partial font color (red) found in B1 match by column A.

Hi Everyone! I am a beginner to macros and just received help on another question here. I would like to adjust the code however, and have been struggling a lot. I just wrote a macro which compiles data from different workbooks into one compiled data workbook. This compiled data is structured as...

Hi All, I have a spreadsheet that contains a list of transactions. Column A contains each transaction ID, Column B contains all individuals involved in the transaction (delimited with semi-columns), column C contains the transaction dates, and Column E contains a list of all unique individuals...

Hello, I am trying to create an aging table for receivables. I have a report that gives me all the detail of what is outstanding but I want to convert the data into 5 buckets. The report gives me the name of the individual, amount, and what term it was from. <tbody> Name Balance Term...

So, in other words: I have cells that contain text strings. The text strings may or may not contain numbers. In the event that they DO contain numbers, I'd like to set up some way to automatically make JUST THE NUMBERS bold. \ Is this possible? Either via Conditional Formatting or VBA? Thanks!

Hello All, I'm getting an excel report from a web page which has a column to show the time of actions ( ex. 12/3/2018 7:25:42 PM). Now I need to count the dates, time range and date range. I wonder how I can Vlookup fro specific date, date range, time range and count them? I tried to split...