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...
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...
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...
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...
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...
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
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...
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...
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...
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..
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...
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...
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
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...
Using Excel 2000
I need VBA, which can do the following task...
1-Column C:D rows highlight in the colour "Light Pink", in the case if finds any same or reversal patterns in the Columns E:F, G:H, I:J, K:L, M:N or O:P same row.
2-Highlight 3 patterns, which can be the same and can be...
I'm writing some code where each result needs the colour changing and the border setting.
The colour is fine as it's only 1 extra line of code however the border is a few.
.LineStyle = xlContinuous
.Color = vbRed
.Weight = xlThin
Is there a...