colour

Hi In my sheet, columns a, b, c and d can contain either "yes" or "no" - the rest of the columns contain text I want to colour the row red if any of abcd contains a no I want to colour the row green only if all of abcd contain yes I then want to count how many rows are coloured red I then...

Hi running 97 at work. Got vba code to count cells based on colour . Now want to be able to count based on contents ( text - names) and their colour. How do.i do it in both 97 and 2018?

Hello all, i was kindly helped with a vba code today, which worked great, but i've come across another issue. i have a summary sheet with a list of suppliers, which all have their own tabs. i wanted the suppliers in the summary sheet to match the colour of the sheet tabs. my problem is when...

Hi All, I have a summary sheet with all my suppliers on it. is there a way I can colour the supplier names in the summary sheet with colour of their tabs. thanks in advance.

Hi. Can anyone tell me how to add a formula that automatically changes the colour of a cell to red once the date within that cell expires please? Thanks. David

Hi Everyone, Ok so I'm looking for away to set up condional formatting or a vba to do the following Range AL51:AL800 if cell value = "a" then cell and the 14 cells above true, or colour fill white. so basically, for every cell in the range if there's an "a" that cell and the 14 above it are...

I have found VBA code from another thread that returns a value for a cell colour. But it will only update when F9 is pressed for a cell colour change In B1 =GetColor(A1) when colour in A1 changes B1 output stays the same CODE: Function GetColor(r As Range) As Integer Application.Volatile...

Hello I am trying to set up a staff spreadsheet so I can track when the qualifications are due. I already have a spreadsheet with the dates the staff did the training an would like it to change colour so I can easily see when they are due this year. Could someone help with this please?

Hi I have data set that changes regularly. When the data change what I want to have happen is to have the row colour like a table would base on the date in column K. i.e that is were the date is the same I and the row to be coloured. If only on colour an be used then colour the even or odd sets...

Hi all, Wondering if this is even possible... Is it possible to set up a slicer so if when items is selected, the colour be synchronizes to the PivotCharts 'line' the Slicer is linked to? Furthermore, can this be applied to when multiple selections are made? E.g. Three people, Three names...

Hello there, I have a range of shape names followed by various values which correspond to the colours which I'd like to assign. I'm having problems piecing together the VBA code in order to update the shapes in one go. My data source is on the sheet named "Data" with the shapes on one called...

How to count colour cells in conditional formatting Rgds Alok

Hey Excel Guru's I need some Help to change Colour if Multi page is Activated By Double-click on Specific cell.... All the Function with Double-click works it's the Colour Part i need... example I Double click on Cell "B1" then the Multi page side Should Change Background - Colour So that...

Hi, I am using a vlookup formula. Which works well to pull data from my other sheet. But I want it to just pull the colour only from the cell Example: Data (jan) from cell a1 is a Blue colour, and has a number example 5. Vlookup sheet (e4), overwrites from the information of the data sheet...

Hi Can anyone help with the following problem , the black cells in rows 47-52 appear according to the number in row 46,these are formulas that count the number of 5's in the column above, I would like these cell to be colour formatted eg the first 5 in j16:j36 to appear but be colour formatted...

Hi all need some help on a formula for a crochet pattern. I have 6 colours and on each piece the colour can be used only once. there are 4 rows on each piece. Row 1 is a single colour, rows 2 & 3 have 2 colours each and the 4th row is also a single colour. eg row 1 - yellow row 2 - green and...

Hi I would like to format 2 or 3 cells based on the colour of another cell So when the cell goes to Red i want the other cells to have no fill Any other colour and they display their information Help much appreciated

I am trying this formula =IF(OR($K7="2",$K7="3"),OR($<wbr style="color: rgb(31, 73, 125); font-family: Arial, Helvetica, sans-serif; font-size: small;">M7="LIL",$M7="BEG",$M7="GWY",$<wbr style="color: rgb(31, 73, 125); font-family: Arial, Helvetica, sans-serif; font-size...

Hi Excel-experts,i find this code on internet: Private Sub Worksheet_SelectionChange(ByVal Target As Range)Is it possible to run anything like this, but then for 'Colour change in cells'? I would like my sheet to react on change of backround colour in some specific cells. Thanks in advance, Johan

I am trying to count the total number of cells that have a particular colour. I have attached the sheet in question and need values under "Total" for the particular colours. Thanks