colours

Hello there. I want to sort a coulumn of numbers in 3 colours, so I was trying to use conditional formatting, but I can't seem to get it right. I managed my own rule with a "3 colour scale" but as I apply it to selected coulumn, nothing happens. Do I maybe type the rule numbers wrong? This is...

ok so my problem is that i currently have two rows of images, one for home kits and one for away kit images for a football database i entered. this being my current formula to pull the image dependent on the match that is requested by the user...

I have a table that is subjected to conditional formatting and works exactly as required. I have the need to copy that table and save it in it's own workbook and this is where the problem is. The code used is as follows: Dim Pth As String Pth = ThisWorkbook.Path...

G'day Magicians Can someone please help me with this one? I have a macro that colours cells AF2:AF6 with lime green (65250) and also colours some of the cells in U2:U6 I want to add to that macro or create another macro that will look at those two columns and if there is a cell coloured in...

Using Excel 2000 Hi, I got results in cells C8:C70 Define colours in the cell F7:F16 as shown for different 9 patterns. In the cell C6 got 3-X, I want to fill all 3-X find in Column C with colour is find in cell F15, and only the below the 3-X fill colours as per pattern (colours shown...

If I have two charts in my excel spreadsheet and both use the same data series, and the data series are both labelled the same in each chart, is there a way to copy the formatting from one chart to the other? i.e. I want the colours selected for each data series in one chart to match those in...

I am just curious if am I doing this a rather more laborious way then is necessary. I have 12 sheets on the workbook in question, each sheet had a vast range of conditional formatting. Every year when I update the workbook and colours have to change, I alter the colours and then go to 'Fill...

Hi Everyone I am faced with a task of replacing colours with different shades. The demanding part lies in the conditional formatting, which turns out to be highly convoluted, most probably as a result of much reorganising to the rows and columns done after the conditions were set up. To...

Help! I am trying to change cell colours using conditional formatting but it's not working. I have an 'IF' formula in one of the cells I'm trying to change colours on so I'm assuming that's why. It's changing all the other cells except the one with the formula. Is there a way around it please?

Well, I am under no doubt this has been answered a million times, but can I figure it? Hell to the no, is the answer!! So I need your help. I have created a map of the of South of England, but post code region, which is the important bit, and the reason why I have created one rather than...

Hi Guys, I have a file and i think its become corrupted. If you click in the formula bar although the formulas seems to be ok, the text is all in different fonts and colours. Any thoughts? Is there a way to run a scan on a excel file to try and clean up any errors. Thanks

At work i use excel to create a customer demand plan. one column has codes in which I have to use "find & replace" to turn them into names of colours. This is very time consuming, is there any way that excel can do this automatically?

Something has changed in the Forum. It used to be that when I pasted Excel data with the HTML Maker it would display the fill colours. Now, it doesn't (like here, where F17 though G32 should have been Green and also Rows 5 and 22 had some yellow...

Hello, Has anyone used this and managed to get it working: GitHub - gallaux/VBEThemeColorEditor: The VBA / VB editor (or VBE) is limited in the 16 colors it can use to render code text. This application replaces the default colors with custom palettes that can be saved and loaded. It is...

Hi there, I have been presented with some 20 plus templates, each workbook/template contains between 5 and 20 sheets, depending on the sheet, they make have extra items, charts, different shapes and maybe some tables. I have been told to change the generic colours to keep up with the new...

Hi Everybody I hope you can help me - I have been searching for the answer and got so far but cant seem to get over the final hurdle I have worked out how to create a bubble chart and pieced together a macro from others work, with the aim of making the bubbles coloured based on a column of...

Hi, I've used PowerPivot to get some data out of an Oracle warehouse, the data includes a total number, and then a target for the week and a cumulative target for the week so far. I've then created several if statements in new columns to determine whether the total has met either the cumulative...

Hello, I'm having some difficulties trying to customize the colours of separate plots in a scatter graph. I have 6 different data sets to put on one graph and am trying to make the symbols for the data points as follows: - 1 set solid green circles - 1 set open green circles - 1 set solid blue...

Hi all, I'm just bouncing for ideas here, but I basically need to find a way of using a ListBox look a bit prettier than it currently does. I am pulling information from an Access database into Excel and I need to display a large volume of information in an easy to read manner - the easiest of...

These are the values and their formats MPC1 = Red MPC3 = Pink MPC4 = Yellow MD01 = Green Mm2b = Cyan FP1 = Purple PH01 = Blue PH05 = Orange IT3 = Black Each with white text. im no good with vba so am pretty hopeless