color cell

I'm tryiung to find info on how to find out if a cell have a color or not? I hope it can be done with normal formulas, but if I need the VBA support I hope you can explain a bit more since I'm not so good at that (where to put the script, and so on). Deeper decription: I have a range of cells...

<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/>...

Hi, I have values that I want to color code in my table. Originally I was tagging them as numbers, but instead I need them as colors. Function conversion(pVal As Double) If pVal > 0.05 Then conversion = "1" ElseIf pVal > 0.001 Then conversion = "2" ElseIf pVal >...

Hi, I have a workbook with certain cells already in colour. It's for shift patterns for my workers. Pink is nightshift, yellow dayshift and white is off work. I then have a drop down so I can chose 1, 2, 3, H or S for various tasks they complete. 1 perfect, 2 OK, 3 bad, H holiday and S Sick...

Firstly, thanks for taking time out to read this. Secondly, I hope you can help! I'm trying to colour columns 'A' thru 'O', based upon data entered in cell K. Currently, I've got the following code made up to do this, but it colours all cells from A through IV on that row. Is it possible to...

Sheet 1 called Data has fill color (yellow) for some cells in row 1, eg B1. Sheet 2 cell B1 has =Data!B1, what else do I need to add to the formula so that cell is the same color as the cell in Data B1 (yellow). Thanks for your help in advance.

:confused:.... So I am trying to apply conditional formatting to a document of mine and I cant seem to figure out how to make this conditional formatting work. I have in column A numbers formatted this way, here is an example: 00087965. When the numbers are not formatted this way I need it to be...

I have a spreadsheet with a series of 31 tabs that record test results. Those individual test results are recorded by selecting a value from a pull down menu and clicking on one of six values. The values are either "pass" or "fail". In the same excel spreadsheet I recap all the pass/fail...

I want to have the macro delete the color applied once a new "Row" is selected! Private Sub Worksheet_SelectionChange(ByVal Target As Range) Dim RR As Range Set RR = Target Cells(RR.Row, 2).Interior.ColorIndex = 36 Cells(RR.Row, 3).Interior.ColorIndex = 36 Cells(RR.Row...