vacant

Hello all, this is my first post. Sorry if I violate any norms or post a question previously answered. I have multiple worksheets in a workbook that contains tenant information for apartment buildings. On those worksheets, I note a status for each tenant (occupied, vacant, or notice). I would...

Morning gang! I finally got the code below to work with a color change, but I am struggling to get it to change the corresponding tab name. My goal with the code is to have cells A16 to A83 on my rent schedule tab, change the corresponding tab name and color with the content therein. For...

Hello All, Can anyone please help me with this problem. In cell M2:M151, the user needs to select a value from a list ( R2:R18) which I have made through data validation feature Now the user many times does not select any value and keeps the cell vacant ( Note cells R12:R18 are vacant at...

Hi All, I need a bit of help here. I am trying to utilize the word "Vacant" to trigger a tab color change on my workbook based on a value entered on another sheet. The code works as intended when I enter "Vacant" in cell $DB$7 on the same sheet but, when that cell is linked to another sheet...

I have a workbook that i track rent. Tenant name is recorded in Column B (Cell B4 starts the list) When a tenant moves out i type VACANT in column B In column I the amount of rent is entered. Is there a formula i can put in column A that will make the word VACANT appear in in column B when...

So in cell D5 i have my rent amount. In cell B5 i have the tenant name. If there is no tenant then in cell B5 i type VACANT. is there a formula that i can type in cell A5 that will automatically populate the word "VACANT" in cell B5 if there is no rent entered in cell D5?

Using Excel 2016. Windows 7. I'm stumped and need help. A new real estate investment property was purchased that contains vacant and occupied units. There are two kinds of vacant units: Vacant Penthouse Units (PH) and Vacant Units (or all others that aren’t PH). There are a total of 14 Vacant...

I have two columns of data, one is strictly numerical (other than the header) and the other displays a text string depending on the nested if. My problem is that I want to find the number of times each of the 3 text possibilities correspond to each numerical value. Column D contains either 5...