colour

I have been trying for hours at various VBA codes but havnt found a specific formula that works. My team have a form that we use to generate work instruction which is basically merged cells with instructions prewritten that they highlight a number of cells ( A1 to A8 ) and then 'fill colour' in...

Hello,</SPAN></SPAN> Require VBA which can colour number of sequence with 3, 4 different colours </SPAN></SPAN> 0 = no colour, all 1=single colour, rest 1+2, 1+2+3, 1+2+3+4, max sequence I got </SPAN></SPAN> 1 to 14 </SPAN></SPAN> Here is an example... </SPAN></SPAN>...

Hi All, I've created a spreadsheet with conditional formatting to colour the cell basedon the vale in the cell. I can’t for the life of me figure out how to in thenext cell input one of the 4 options based on the cells colour. Example: All colours in cell are due to conditional formatting and...

Hi All, Is it possible to do the following: Change the background colour of a cell based on the background colour of a cell on another sheet. I would like to have 4 pages all linked together whereby if i change the background colour of a cell on the master sheet (B12 for example) then the...

Hi I've researched and I can' find what I want the code do: I want a code that will change a button's colour when it's clicked, but when another button is clicked it would change that button's colour and reset the previous ones. I'm not too sure if there is a way to do it without linking to a...

I am trying to change the colour of a cell in column A from information I have on a form. I have managed to change the colour of A1 with the below code, so that part works, but I want the Range ("A1") to pick up inflation from a text box on the form (Form1.txtRow). I have tried what I can think...

Hello! Is it possible to colour a part of a line in a graph based on the colour of the source cells? Thanks!

Hi, I'll explain the purpose of my spreadsheet before I say what I'm trying to achieve as it might make more sense that way. I've been asked to create a spreadsheet to log when we have cancelled a sales order and why, but in such a way that it will be a visual checklist. I know that there's a...

Hi, I have a master document that goes form Cell A1:BG22458. i want to create a summary report with just 6 columns. 5 are a simple link, the other requires a formula. In Sheet1 I have set my summary tab up. Sheet 2 is the master data. In Cells F1:F22458 all cells contain number of words and...

Hello,</SPAN></SPAN> I want to set conditional formatting in the columns T:AB using bit odd criteria for example... </SPAN></SPAN> 1-Row T4:AB7 has numbers 0, 1 & 2--->Look these numbers in the row D7:Q7 if have match 0 in the row D8:Q8 if yes then fill colour red and font white in the all (0...

Question from a complete Excel dunce so - you have been warned! :) I need to do a doughnut chart for Jan through Dec and have formatted (manually) the attached (I hope the image comes through ok). https://drive.google.com/open?id=1DYmXE7TO9sXRu6Ox68ODLeWuRa80rpW9 The doughnut in Col F (which...

Hello,</SPAN></SPAN> Not sure can be done "0's" font colour red</SPAN></SPAN> As per example below Book1ABCD123451 | &lsqb;COLOR=#ff0000&rsqb;0&lsqb;/COLOR&rsqb; | &lsqb;COLOR=#ff0000&rsqb;0&lsqb;/COLOR&rsqb; | &lsqb;COLOR=#ff0000&rsqb;0&lsqb;/COLOR&rsqb; | 1 |...

I'm trying to find a way to change the background colour of textboxes on a userform to assist users who have dyslexia. I thought it might be as simple as setting their preferred colour on installation of the file, then calling that colour each time the form is loaded, but it doesn't work. This...

Hi all, I'm trying to change the "automatic" font colour to my company standard colour in Excel 2016. It seems it used to be possible to set this colour in Windows "Personalise" in previous versions of Windows, but Windows 10 works differently and doesn't allow this any more. VBA seems to think...

i need to calculate, how mant minutes its takes to reach temperature 120(T1, time corresponding to blue color numbers), after reaching 120, how many minutes it is in between 119.5 to 120.5 deg temperature(T2, time corresponding to red colour numbers), and how many minutes after T2,(T3, time...

Hello All, i am having issues with creating CF for a specific column. column is for delivery ETAs. so most of the cells have a date in it, so the column is formatted to dates. however for some of the cells we are waiting for the ETA so have "pending" written in it. i can't seem to be able...

Hi, In a range I have a conditional format to colour cell if = "H" but when I delete the cell contents the colour still remains, I don't know why this has started to happen i'm sure before the cell returned to a no fill status. Any ideas?

Hi good morning, please can you help me I have the 2 codes below one for the update button where it updates and finds the ID number in sheet 1 and updates the data into the correct cells, but it should also colour code that line once updated if a specific textbox has data in it. But what it is...

Hello :), good morning all. Just wondering f you can help please. I have the code below, but this time I want the row to change colour if anything is entered into the textbox so not word specific I have tried for the TextBox14 value "" and "*" but that didn't work, please can you advise...

Hi all, I am unsuccessfully trying to speed up my un-highlight selected cells macro. I have been toying with the code to speed it up as if I mistakenly select an entire row it takes a long time to complete. But I am too useless and have failed to get it working correctly. I have also been...