filled

All, I will use column A and B as the columns I want to change: I want to make column A Red if column A is not filled out but column B is filled out. But I want to leave column A White if Column B is not filled out. I have not been able to figure that out.

Is it possible color a cell & have a value populate another cell? So if I filled cell D1 with RGB(0, 176, 80)...Cell A1 would ="1". <colgroup><col width="64" style="width: 48pt;"> <tbody> </tbody>

hello everyone i tried to calculated life cycle in numerology.so life cycle period filled in cell M35 - DH35 and cells are filled automatically and changed at a certain age based on the Time value (cell D6) there is 3 period first Period = result from single digit of month of birth except the...

Hi all, I have a userform with a group of 9 text boxes that I would like to check. If the user has left them all blank or filled them all, they should be able to click "OK" and complete the form. If the user has only filled in 1-8 of the textboxes, I'd like a message box to display telling...

Using Excel 2010, column C includes values, some of which start with a number and others which start with a letter. Like this: 1) Footnote 2) Footnote2 a) sub footnote b) sub footnote 2 3) Footnote3 a) sub foonote I am seeking a method to indent the sub footnotes, the cells which do not...

I have a specific range on my sheet e.g. ("G10:G21"). (12 cells) Within the range I’m expecting a variable No. of cells to be filled, but at the bottom of the range. It may have only 1 cell filled, or 11 filled. But there will always be a blank at the top in G10. What I want to do is fill cell...

Hi Guys, As the title indicated, I tried the Vlookup formulas in cells which is filled in colour to indicate the Status, but it doesn't look up the value(colour) Could anyone help me to come up with a formula to look up the colour as per items? any help would be greatly appreciated ! Thanks

Hiya, I am a novice in VBA (this is day 2) and wanted to write a script to copy some values from sheet to another and fill down to the last filled row. This is what I have so far: Dim lRow As Long lRow = Worksheets("Data").Cells(Worksheets("Data").Rows.Count, "A").End(xlUp).Row lRow = lRow...

Good morning, I am trying to create a weekly on-call schedule. There are 12 on-call spots that must be filled each week. The first 11 spots will be filled from a list of 21 people (MEOs) and the 12th spot must have a person from a list of 5 people (Pumphouse). The goal is that no one is...

Hi, I have a problem with VBA in excel. My code works fine for every table except when I have just 2 rows then I have error. First row is filled with column names and second rows i filled with formulas for each column. So if I have more then 2 rows everything works fine, but when I have just 2...

Hello! So I have quite a weird problem. In column B and C I both have stuff and a lot of blank cells. What I need to figure out is that I need to fill up column B (not everywhere) the following way (this is just an example, not the real values): What I have: <tbody> Banana A Orange...

Hi All, I'm trying to create dynamic ranges using the offset function. The number of columns in the range needs to be the first 'filled' cell to the next 'filled' cell less one. Example: | Low | | | | | | | medium| | | | | | | | | | |...

I've a range of text with details such as Name, Email ID, Telephone and Address. I want the all the address lines to be combined into once cell separated by line breaks as given below I've been using "kutools for excel" combine rows option for these kind of functionality and it is okay...

I've a range of text with details such as Name, Email ID, Telephone and Address. I want the all the address lines to be combined into once cell separated by line breaks as given below I've been using "kutools for excel" combine rows option for these kind of functionality and it is okay...

I have a column filled with the following formula: =SUM(INDIRECT"'"&VLOOKUP($C$1,LookUpData!A:F,6,FALSE)&"'!Chase")) But from time to time, after a review -- I need to add "1" to the $C$1 (numeric entry) to several cells only. I'm hoping to use C/F to highlight ALL CELLS that contain the...

Greetings people, I am having a huge blockade right now and I would need an inspiration... I built a database for our employee to fill in. From Time to Time, we know that false information can be filled in. I have certain "Keys" that guides me to check if what they have filled in is correct...

Hello, I'm trying to create a form that cannot be printed unless certain fields are filled in (A1, B19 & B45). Been using VBA and found this online: Private Sub Workbook_BeforePrint(Cancel As Boolean) If Sheets("Cover Sheet").Range("A1,B19,B45").Value = "" Then Cancel = True...

So basically what I have is a project management worksheet that I would like to get how many saw jobs I have that are not done. What I have is a part number say in A1. B1:N1 would be all the operations that the job needs to go through, like saw, laser, bp, mill, bend, ...When an operation is...

Hello, I have a booking slot system with slot times 0600 - 2000. there are 53 in total and I want to copy the data into an excel file and have a pivot show the percentage of slots filled. Each slot filled with have a 5 digit reference number entered and empty slots will just be blank. Is...

Hi everyone, I have a bit of a problem as I am not to good in Excel and I don't know if this is even possible. But I want to multiply an entire column (column A for example) by the same number (for example 3). The problem is that only one cell contains information. Let's say I only have the...