coloured

Hi All, have a question. In C column I have my product serials. I want to look for them in column A and if they have a match I want the City names in D3, E3, F3 etc. So I want them horizontally. Tried to to it with index and match, managed to do one line but then were not able to pull it down...

Hi Guys, bit a headscratcher, I have a roster that im trying to calculate. The roster has several employees, each with there own colour and how many hours they have, eg, A1, A2 and A3 are Green and have 1 in each cell. So lets say Alan, who is "green" will have a total of 3. Is there a...

Using Excel 2000 Hi, I need VBA to get coloured 0 as shown in the example below <colgroup><col></colgroup><tbody> 0 | 0 | 0 | 1 | 1 | 1 | 1 0 | 0 | 1 | 1 | 1 | 0 | 1 0 | 0 | 1 | 1 | 1 | 1 | 0 0 | 0 | 1 | 0 | 1 | 1 | 0 0 | 0 | 1 | 1 | 1 | 1 | 0 0 | 0 | 1 | 1 | 1 | 0 | 1 0 | 0 | 1...

Using Excel 2000</SPAN></SPAN> I got data in the column C (A, B, C, D and E) separated by vertical bar and there is a one space between vertical bar also that I want to coloured all different colour but each alphabet must be the same colour in the below example there are coloured only row 5 & 6...

Hi,</SPAN></SPAN> I got patterns divide by 3 groups as shown in the cells C1:F3, and the conditional formula in the Column D6 to down is applied by formula is find under this link</SPAN></SPAN>...

Hello I would like to add to this piece of analysis below to pick up if Cell L6 is coloured red is there a way to do this please? =IF(E6="","",IF(B6="",TODAY(),E6)-B6) Thank you in advance

Hi All, Could someone help with with the condtional formatting of dates and differnet rules please. If A1 has a date of : Monday - Friday 07:00 - 21:00 and Saturday - Sunday 07:00 - 16:30 = B1 to be coloured AMBER Monday - Friday 21:01 - 06:59 and Saturday - Sunday 16:31 - 06:59 = B1 to be...

Hi all and thanks in advance for your excellent help :) I've applied conditional formatting to an area of my spreadsheet so that when all cells containing N/A are coloured green. However, when I applied this rule not all the cells in my selection that contained N/A were coloured green. All...

I want to do a custom sort. I want to sort C first by coloured cell, fine. But I then want sort by data in K where they have the same data as whats coloured in C but these cells will be clear! How please?

If cell AJ4 is between 3.9% and 12.9% I want cell O4 to be coloured green. Struggling to get the simplicity of it, any pointers appreciated.

My wife's working on a spreadsheet, and wants to do something which I'm hoping conditional formatting can sort for me, but we're both stuck. It's basically a calendar, and 2 of the rows (let's call them row A for preparation date and row D for work start date) need to work in conjunction. So...

Hi, I format a table row-wise with the following code: Code: Selection.FormatConditions.Add Type:=xlExpression, Formula1:="=MIN($T2:$DZ2)=T2" Selection.FormatConditions(1).Interior.ColorIndex = 37 and this, if an "x" occurs in a cell: Code: If InStr(1, rngCell.Value, "x") > 0 Then...

This is a request to Rick Rothstein and Peter_SSs who created the following VBA script in another Thread to do with underlining key words in a cell range > I'm looking for a similar solution except I would like the "Words" sheet "Data" to be converted to Bold and Red text. My Sheet with the...