How to add a drop-down list to an Excel cell and conditional color formatting

To add drop-down list to a sheet, do the following: Create the list in cells A1:A4. Similarly, you can enter the items in a single row, such as A1:D1. Select cell E3. (You can position the drop-down list in most any cell or even multiple cells.) Choose Validation from the Data menu. Choose List from… Continue reading How to add a drop-down list to an Excel cell and conditional color formatting

Excel Last Character String Match In a String

Let’s say for example you want the right-most \ in the following string (which is stored in cell A1): Drive:\Folder\SubFolder\Filename.ext To get the position of the last \, you would use this formula: =FIND(“@”,SUBSTITUTE(A1,”\”,”@”,(LEN(A1)-LEN(SUBSTITUTE(A1,”\”,””)))/LEN(“\”))) That tells us the right-most \ is at character 24. It does this by looking for “@” and substituting the very… Continue reading Excel Last Character String Match In a String