filling

Hello everyone, I have data like this 12 23 35 44 45 6 3 9 I would like the show them: highest one filling red lowest one filling green 2nd highest one filling yellow 3nd highest one filling blue is that possible? The...

Hi, Trying to colour a cell on one sheet if the reference number entered already appears on another sheet. Googled various options as it keeps filling the cell above instead... The rule I tried is =MATCH($A2,'DNA No Support & WD Pre Census'!A:A,0) Thanks.

Dear Sir, How to fill combobox with values from another workbook in VBA Regards

Greeting, First of all, thank you very much for such a site and it has been so helpful for me. Problem: so I'm doing an almost daily task which I couldn't do it by macros, I'll explain it by an example; For example, let's say that here I have the following table in Sheet1: Order No Color S M L...

Hello. I see where I can fill an empty cell with the value above or below but how about the cell to the left? Thanks

Hi everyone, I want an order straight down for automatically filling in excel. Like this: '=INDEX(Sheet2!$1:$1,(COLUMNS($A:A)-1)*2+1) &", "& INDEX(Sheet2!$2:$2,COLUMNS($A:A)*2)' '=INDEX(Sheet2!$2:$2,(COLUMNS($A:A)-1)*2+1) &", "& INDEX(Sheet2!$2:$2,COLUMNS($A:A)*2)'...

Hey All Can't seem to work out the correct method for this. I want to select and then Autofill a set of Formulas but no matter what I try I keep getting an Error :( This is what I started with that I thought would work; Range(Cells(j, "E"), Cells(j, "G")).Select Selection.AutoFill...

Hi , I would like to hide some row that doesn't have any value for each cell within a row, here below sample table : <tbody> Items / Stocks Nov Dec Jan Feb Office Desk 3 pcs 6 pcs 10 pcs Office Chair 20 pcs 40 pcs 10 pcs 80 pcs Printer fax machine 3 pcs filling cabinet...

This is embarrassing... I have a modified ridiculously large spreadsheet that someone else built pulling data from all sorts of weird locations. i did not save a backup copy.... now the file will not open and get's stuck at the filling cells part of opening. i wonder if there is a way for...

I have a header row in a single field in column 1 in the following format: Scenario: Actual Year: 2018 Period: Jan Value: <(Entity)> Below this I have my normal data columns. How can I unpivot this single top header field so that I have just the Year (2018) filling down one column and the...

Hi There, I'm having some real trouble with what is the best way to do this: In column J I want to return the value in column C based upon criteria in B and D. This is the formula I have been using in J1: =(IF(D:D = "filling",VLOOKUP(I4,B:D,2,0),"")) <colgroup><col width="64" span="9"...

Have a good day everyone! Problem : Row(s)/cell(s) automatically will be locked after filling colors I know this may sounds like a broken record , but i can't find previous thread about my excel problem. Can someone help me please..thank you in advance.

I am making a payroll reporting worksheet and want the top of each column to have "WE" and the date of every other Friday in the cell. i.e. <tbody> WE 09/11/15 WE 09/25/15 WE 10/09/15 </tbody> My problem is how can do I get the date to fill every other week when I drag it out? I have...

Hi! Does anyone have a solution on how to fill a value upwards until a new value appears? (and then repeating the procedure after the new value) I know this can be done downwards with "find -> blanks, entering a formula and then ctrl+enter" but I cant figure out how to make it work upwards...