filled

I need to have J29:J215 filled red or K29:K215 filled red if J29:J215 is blank and there is a value in that row (A29 or K29 or Etc...) I tried conditional will all values that are blank, but all the cells below the rows that I have data get filled. I only need the the fill when the cell in...

I have a combobox where i am trying to get the list o refer to a horizontal list with he first cell named BBFCRatingStart and then to finish at the end of the list depending on how many cells are filled in this is what i have but clearly i am doing something wrong. wsLists is is the name of the...

Hi Anyone could help me to with coding to auto sequentially number the rows when they are filled . I have tried the excel formula but failed as the rows are filled by a macro. Thanks

Hi all, I am a trader and very much a vba novice (so please use very small words!). I have a spreadsheet from my broker, on which I have built a trading system. Everything works very well, but approximately 10% of the time, the "order status" does not fill back into the spreadsheet and I use...

Hello Folks,I have a very complex requirement. I need a macro to multiply based on some conditions. I have a two column one is filled with "Y" and "N" letters another one is filled with numbers. My requirement is to identify all the "Y" succeeded by "N" and multiply the value of adjacent cell to...

So, I have some code (see below) that won't allow users to save the spreadsheet until certain cells are filled in. I now want to include code that will remind the user to save as macro enabled spreadsheet (xlsm), but only if the file isn't already xlsm. Here's my code so far: Private Sub...

Hi I need some help please! I have 3 cells - A1 contains a value; B1 contains a value; and C1 is to be formatted with a RAG status colour. If(A1>B1) then C1 should be filled green If(A1=B1) then C1 should be filled amber If(A1 <B1) then C1 should be filled red

Hi All, Just joined the forum.....this is my first post.... I have a table that has a drop down list say in row cell C33. When I select an item from C33, row cell A35 is filled. And when I do a second selection from C33, row cell A36 is filled and so fort...... I am finding it difficult to...

Hi fellow Excel-freaks, I have an odd request. Usually a cell Spillover is not possible if the cell to the right is filled with anything. Does anyone know how to force a spillover even though it is filled? thanks for all suggestions BR

So I'm working in a template that the estimators use. I'm setting it up so that they cannot save it without certain fields being filled in. However, how do I save the template with those fields blank?

I have a spreadsheet that will be filled in programmatically. I'd like the cells that will be filled in this way to be written in an alternate color. I know that I can do something akin to: Range("A1").Font.Color = vbRed However, I don't want to code 90+ lines of color changes. Is there a way...

Hello Everyone, I have a bit of a brain-scratcher that I have been working on for a few days and most of my original methods have been quite manual so I was hoping to see if anyone had any suggestions on how to reduce the manual part of this problem. Basically I have a bunch of transactional...

Hi Everyone, I have a tricky one here that I will do my best to explain. I have multiple columns of data where the rows are entirely filled in, partially filled in, or completely blank. My original goal was to count each row that was not entirely blank. An example like this: iiiiA B C 1...

Hello, I am trying to write a code that when I press a button I get an X inserted in the relevant cell. If Z5 = 1 then put an X to AB5 if Z6 = 2 then put an X in AC6 (See Below). Eventually the Periods will change and AB through AE should be all filled out with Xs. The range is dynamic so...

Dear Experts, I have an excel sheet data and i want add remarks against emplyee code in remarks column. Data is as per below details. Column A - Emp_code (Already filled) Column B - Emp_Name (Already filled) Column C - Remarks (Need to fill by user form) Kindly help me out and give me user...

Using Excel 2000 Hi, Data are the numbers shown in the cells E6:E15, which I want, could be filled in column D, Part1-counting the cell down to D6, if D6 = 0 than 5 will be filled in cell D10 counting to down 12 will be filled in cell D22 and so on for rest of the numbers are in E6:E15...

This is kind of a piggy back to another forum "Adding Up Several Percentages". Basically I have a row of x's 98 cells out. With those 98 cells I want to try and get a gradient stretch across all cells at the same time. So if all 98 cells are not filled with an X i would like a percentage of it...

Hi all, I wonder if someone can help me with a formula please I cannot get my head around it so its best to write it in words: It is so difficult to explain my actual spreadsheet but here goes: The formula would be filled down the column starting in O2 If the date in E2 IS LESS THAN OR EQUAL...

Good afternoon, I used to know how to do this but have since lost my knowledge. How do you force a cell to display "" When two other cells are not BOTH filled in for example A1 to display "" if B1 AND B2 are both not filled in

Hi, I wonder if anyone can help? Am using Excel 2016 I want to conditionally format 2 columns of cells based on the % of another column What I am trying to do is format cells A2 & B2 based on a % of C2 (which is hidden) I would like cells A2 & B2: To be filled Green if they are between 71%...