1. S

    Increase number in formula when using fill

    I have the following formula in column A1 =IFERROR(LARGE(UNIQUE(B$2:B$100),3),"") So when filling cell A2 with this formula, I would like the number to progress, for example: =IFERROR(LARGE(UNIQUE(B$2:B$100),4),"") It's possible?
  2. K

    Fill by matching and adding rows for multiple matches

    Hi! Unfortunately, my xl2bb still refuses to work (blanked out in the excel toolbar) but I'll save that for another post and just attach images here. I also previously posted the same thread but with very unclear and messy parameters so I'm redoing that here, apologies for that. The Sales...
  3. K

    Fill Down to a Specified Row

    Hello. Please help me fill down to a row # specified in another cell or fill down a specified number of cells.
  4. Jyggalag

    Two different colors in a cell?

    Hi all, I currently have the following table: Is it possible to make it so cell A3 has the same color fill as cell A2 (light blue) until it reaches "Week:" where it would then have a yellow fill? Thank you! :)
  5. M

    Using an Excel Formula to Filldown

    Hi all, I'm looking to filldown my formula using a formula (if that's possible). If anyone has knowledge on how to do this it would be really helpful. Here's the example formula I'm looking to fill down using only in cell formula. Formula works alright as is.. but instead of having it bound to...
  6. O

    Searching for "no fill" cells

    I have been using excel to keep up with my inventory. When the product has been purchased, I "fill" the cell in a blue color. Now that I have thousands of products, it has become tedious searching for an item that has not been filled. Is there any way to only search for items that do not have a...
  7. X

    Excel VBA for cell colour format to carry over to another sheet

    I have a sheet, let’s call it “Results”. On this sheet there are many columns for each category: “Science”, “Math” and so on so forth. each individual student are named on the rows. Eg: Working Sheet Science Math Student A 70(LGreen) 20 (Red) Student B...
  8. D

    Conditional Formatting Letter Grades - "Minuses" Not Working

    Hello, I'm sure it's out there somewhere but I haven't been able to find it yet. So sorry, everyone, I'm pulling you into this. I have created a worksheet of letter grades and would like to do a conditional format color fill of the cells for every letter grade in the same cell. These grades...
  9. D

    Conditionally format cells to red color if cell 4 rows to the left is not blank

    Hello everybody, I currently have the following list: I want to create a formula (probably through conditional formatting i'd imagine), that basically says: If the cell 4 turns to the left of any designated cell (A1) in row E is not = blank, color the cell in row E with a red...
  10. D

    VBA code or other solution to color cells white if they contain no data

    Hello everybody, I am currently facing an issue. I would like to create a code that colors my cells with a complete white background and no borders if they contain no data (numbers, letters, signs or anything else). Please see the following snip: For the blank cells from Cell A135-D135 and...
  11. F

    Fill Uneven Records Across Columns

    Hi All, Could you please help me find a way to fill in the blank cells that should start from the LastRow + 1 in Col B and go until LastRow in Col C? At the moment the data is just being pasted over the lastrow in Col B. Loop in question is the last one, rest is just used to show more or less...
  12. L

    VBA colour cells based on month

    Hi everyone. I have a table on a sheet that I want to apply to some formatting to. RULE 1 where the B column (or table heading = "VAT quarter") has my VAT quarter end dates in. I want to fill the cell colour based on the month of these in the following way: January = Orange fill April = Yellow...
  13. B

    Transfer Data from 1 sheet to another given conditions.

    Sheet 1 and 2 are a Timesheet setup in a table. Table1 Sheet1 and Table2 Sheet2. Sheet 1 is the 1st 2 weeks of the pay period, Sheet 2 is the second 2 weeks. Formulas in the Table autofill in case a new row needs to be added based on spit days. What I need to do is copy data from 1 of...
  14. L

    fill a range with numbers - vba

    Hi The code below is going to fill a range with random number but all the cells will get the same number. What I want, is to fill cells of that range with different random number. So I am thinking to put that line of code in a loop but how can I loop when user might enter any different range...
  15. M

    Display my chart's font fill color and transparency percentage for all series on a "Chart Details" range of cells

    I'm using Excel 2016. As I keep fine-tuning my stacked area chart's configurations, I find it hard to keep track of the fill colors and series colors. I want to display, for example, in cells B40 and C40 series1's Fill color hex code and series1's Fill color's transparency. And then B41 and C41...
  16. H

    IF to evaluate errors also

    I want to fill D2 as per below criteria’s D2=E2 if B2>0 D2=F2 if B2<0 D2=0 if B2=zero 0 or B2’s formula evaluates to an error. The following error types are evaluated: #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!. How to accomplish please?
  17. H

    4 IFs

    I want to fill D2 as per below criteria’s D2=1 if B2>0 D2=0 if B2<0 D2=null if B2=zero 0 or null How to accomplish please?
  18. N

    Dragging a formula problem?

    I apologize if this has been covered somewhere else, but I'm not even sure how to accurately search for my problem. I have a spreadsheet in which I have calculated a lot of data on 3 separate sheets. I'm trying to consolidate the data into a "Totals" sheet. I have used the following formula in...
  19. PaulJ

    Duplicate value search

    Can some one please provide a formula to allow me to identify duplicates within a specific range. I have a value in a cell H70 which is text that is selected from a drop down list. I want to know if that value has also in another cell (H4 for example). I would like the cell fill in H70 to go...
  20. M

    Conditional Formatting to change the Fill color of a cell based on the hex value of a different cell.

    I have a block of cells A1:D4. I want to set the fill color of that block based on the value of cell F1, which should have the form #XXXXXX, where “X” is a hexadecimal digit. And as I change the values of cell F1 the fill colors change as well. Is this possible? I tried conditional formatting...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back