coloured cells

I have some rows that are coloured in yellow or red and other rows with no fill or a different colour. I only want the yellow and red rows to return a value. When a row has a red or yellow fill, I have a separate column that should return a value (for example: "Y"). If not yellow or red, it...

Hello I have a sheet that contains a column of data running from B9 to B31 inclusive. Some cells are blanked out using the colours ‘black’, ‘yellow’ and ‘blue/purple’. The remainder of the cells are blank (clear). The number of blanked out cells can vary from time to time and may occur at any...

Hi All, I am working on a VBA code that would loop through collection of worksheets (~40 sheets) in a workbook and would specifically pick and copy cells which are coloured in a particular worksheet and then paste the copied range on a separate sheet in the same workbook. I tried to nest a For...

Dear all, I fear there may not be a solution to this problem, but here goes....... I have two spreadsheets. Each sheet has 5 tabs (year 7, year 8, year 9, year 10, year 11). You can download the sheets here: https://docs.google.com/open?id=0B2kA5LQXm97jRGdqTmtKeTI3TEE Description of the...

After doing the following to make cells coloured after double clicking them: Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) If Target.Interior.ColorIndex = xlNone Then ' Then change the background color to red Target.Interior.ColorIndex = 8...

Hi Everyone, im new to this so please bare with me. i have a spreadsheet in excel 2007. It shows a students target grade in one column and their recent test mark in another column. Firstly i have applied conditional formatting to say whether or not the student has hit their target, below or...