1. X

    Values-specific coloured cells to retain its colour

    Sheet 1: Has values like 33.878 in Yellow, 17.873 in Red and 96.666 in Green. Is there a way to ensure that these coloured cells are carried over to sheet 2? (Sheet 2 has a macro that sorts out the scores according to percentile and other considerations so I can’t just copy&paste/use simple...
  2. X

    Fill cell colour according to percentile.

    I have an excel sheet of students with their different subject scores for their tests. Row: Student Names Columns: Subject headers and their scores. (Math, Science, Literature. Is there a excel macro that can automatically help me colour the cells of those in the top 20% green, next 20% light...
  3. 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...
  4. M

    Line graph - change colour if number decreases

    Good afternoon, I have some data already in a combo chart, a mixture of stacked columns and a line. The data for the line predominantly goes up in order, e.g. 1,2,3,4,5 However their may be some instances where the data will decrease, e.g. 1,2,3,2,1 I would like the line for the data where...
  5. B

    Sum of vlookup in multiple rows with condition

    Hi, Let me try and explain what I need with a simplified example: I have a table (H3:I5) that gives me the value for each item (I have dozens of items in the reality). I need, for each month (in B9, C9, D9), to know the sum of the value of each item for the particular month... but only...
  6. F

    Vba help - IF cell has colour & contains text then ...

    Hi All, I am struggling with a code line for a simple macro. Thank you in advance for taking some of your time and to anyone who will help me :) I have 2 sheets ("data" and "macro"). Sheet "data" contains details of users (column A contains data of user 1, column B of user 2 etc) these data...
  7. F

    VBA - Using AND for conditonal formattiing

    Hi, I currently have some vba code that looks at column BM and if the cell is empty then it sets the interior colour to white for all cells in the row (from BM to BZ). If there is something in the cell in column BM then it changes everything in the above range to yellow. What I want to add to...
  8. O

    Conditional Formatting based on Multiple Conditions.(With vba)

    Hi. All i am using excel 2016 i have a worksheet with 100 columns and 5000 rows.. in my data a column heading "Balance in repeating after 4 columns .like Column e, column J........ i want to create a rule for conditional formatting which applies only in column which having Balance, Means...
  9. V

    Conditional formatting colour scales on different cell

    Hi, I have used colour scale to format the % complete cell but I need the format to be the same in column a so I can hide column b. Is there an easy way of doing this I want to keep the colour scale? Thanks <tbody> <colgroup><col><col></colgroup><tbody> Status percent complete Complete 100%...
  10. S

    Counting cells by colour

    Hi All, I am wondering if there is formula whereby I can count cells based on their colour?
  11. A

    Consolidate Multiple Named Ranges Into One Pivot Table In Excel

    Hi all, I am having trouble with the consolidation of my named ranges into the one pivot table to finish a dashboard. I have got all the named ranges into the data source. Each named range is the same shape: that is, each consists of 4 columns. Columns are Amount, Animal, Location, and Colour. I...
  12. E

    Pivot table subtotals for certain fields

    Hello, Using Excel O365. Have created a pivot table and added subtotals as below. I want the subtotal on the MOQ field (and others not showing in the sample below) but I don't want the subtotal on the selling price, cost, margin fields as they are nonsense fields. How (if you can) switch of...
  13. H

    Colour Rows and Columns based on data validation

    Hi I am looking to format my worksheet with different colours based on a data validation drop down list. I currently can get the drop down cell to be the correct colour but would like the whole worksheet (Columns B-J, Rows 2-67) to be different colours. Any help will be greatly appreciated...
  14. T

    Conditional Formatting Help

    Hi, I want to change 4-5 cells black if one of the cells contains the work remitted and if that cell is blank change it red. Can anyone help I have tried various ways and can only make the cell with remitted change colour.. Thanks :-0 Toni
  15. G

    Conditional formatting question

    Hello, I have applied conditional formatting to a range ofcells, for example A1 to D1 and the cells are colour coded based on the value. I am now struggling as the cells in A2 to D2 need to be formattedin the same colour, is there a way to Link the colour format ? SO effectively A1 and A2 would...
  16. H

    Questions on conditional formatting

    Hi, Possible to use conditional formatting to 'sum count' font colour? 1 2 The ans should be 2 'count'
  17. O

    conditional format

    Hi my conditional format is not working and i can't figure out why. i think i have looked at this too much lol. my conditional format formula is: =OR($B18>””,$B18>0) the cell range it is applied to is: =$B$16,$D$16,$F$16,$H$16,$J$16 B18 only ever has a date entered into it if that helps, i was...
  18. A

    Cells changing colour

    Hi I am after a formula that works please If I have A and B. When a date is entered into A1 I want B1 to turn red. When a date is then entered into B1 I want both to turn green. Thanks
  19. J

    change row colour when cell is selected for ease

    Hello I have a sheet but in struggling to see if I'm on the correct row when im filling it in Can you change the row colour when a cell is selected? ie: if I select any thing between G21:AE21 I can get A21:E21 to change colour But if nothing is selected then don't change anything Hope ive...
  20. M

    Colour format based on cell value question

    Hi I've been trying for a couple of hours to conditional colour format cells based on cell value but can't get it right. I have the formulas but I only seem to be able to enter 1 formula but I need to enter 3? My rules are: If B7=>99 but less than 99.9 then shade amber If B7<99 then shade red...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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