color cell

  1. M

    Speed up selected cell fill colour macro

    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...
  2. M

    Macro to sort (first by cell color and then by time in hours)

    Hello! I have a problem with an excel sheet for work. Hope you can help! I have to order employees by their entry time to work, and also by their role inside the company. So, for example: <tbody> Colum A Colum B Colum C 1 Matt (regular employee) 07:00 15:00 2 Philip (supervisor) 07:00...
  3. O

    Cells that automatically change color

    Hi ! I was wondering if anyone could help me. I have provided an image, so illustrate what I mean. As you will be able to see I have a column labelled PM - this column has the initials of project managers. When I enter the initials it will automatically fill in a color. This has been...
  4. C

    If cell color doesn't match highlight the cell

    Hello there! Is this possible in excel? I have cell in A1 colored with blue then cell in B1 colored with blue if they don't match, it will highlight as red. Thankyou!
  5. O

    Lighten cell .background with respect to other cell

    How would you Excel gurus do this? I set the background color of a cell to be of a certain color by using basic functionality in the "Home" tab. I now want the cell adjacent to it to be 10% lighter, and the next cell along to be 20% lighter, etc. So if the first cell is coloured a dark red...
  6. C

    Count Conditional Formatted cells based on Cell color/Colour

    Hi all, Debut post :)! Been visiting this site for a while but FINALLY i haven't found an answer and must now post. So i'm looking for a method that maybe really simple using an assigned number per colour cell, use the number as reference return sub total. But IDEALLY i'm quite simply...
  7. C

    If = to "0" display Message (only once)

    Trying to figure out how to incorporate a CONDITIONAL message appropriately. If ANY CELLS in COL "x" were = "0" then display this message "xxx" Else display this other message "xxx"... If I simply insert the message under the conditional code section, it pops the message up after every row it...
  8. L

    locking color and/or border of a cell

    Hello, I wish to lock a fill/ background colour to a range of cells, and keep it locked in, regardless of the data I input, whether the cell is blank or not, and even if other cells are directly copy/pasted onto it. The ranges are: A1:C25 to be Red Fill A26:C50 to be Green Fill A51:C75 to be...
  9. I

    Color Cell When Cell Value is actually Changed

    I am pretty new to Excel Macros & I have following code in my current spreadsheet as macro to highlight a cell when cell value changes for Column C. The way it works is **************************************************** Private Sub Worksheet_Change(ByVal Target As Range) If Target.Row = 1...
  10. M

    Logical user defined function using colored cells

    Hi, I would like to kindly ask for code for the following situation: I have results (calculated by formula) for a number of people in one column. The top 20% of the results are red colored cells and the bottom 20% of the results are blue colored cells, the cells of the remaining 60% of the...
  11. T

    Help debugging macro

    I'm getting a debug error and I can't figure out why. It's telling me that I'm using an "Invalid or Unqualified Reference" and it highlights the line .Font.Color. Any help would be appreciated. Thanks. Sub ColorCells() Dim rng As Range Dim cell As Range Set rng =...
  12. G

    Range Interior issues

    This is the code I'm using. Nothing complicated... Public Function setRangeColor(fromCellAddress As String, toCells As Range) Dim fromCell As Range Set fromCell = Range(fromCellAddress) toCells.Interior.ColorIndex = fromCell.Interior.ColorIndex setRowColor =...
  13. P

    editing condtional formating rules to change IF "xxx" apears

    Hallo all... pls assist Have set up an roaming calander that is conditional formatted to colour the dates between the start and end date in "blue" from data sheet. If "jabb" appears in the next row i want the rule of the colum above "jabb row" to change to clear "no fill" as if a space was made...
  14. E

    Toggle button, color control

    Hey everybody, this is my first post and my chosen name is not because I'm such an Excel genius... :( Anyhow, for the last three days I'm trying to figure out how to handle these silly toggle buttons. It's the first time that I try to deal with macros (can you actually already call them...
  15. W

    Having trouble with IF statement.

    Hi All, I keep getting an error with the following If statement Dim lastline As Long lastline = Cells(Rows.Count, 2).End(xlUp).Row For i = 2 To lastline If Cells(i, 1).Value = "R" Then _ Cells(i, 1).Select Selection.Interior.Color = 192 ElseIf...
  16. D

    Colour fill (Not Conditional Format)

    Good Day Ladies and Gents Please can you help with the following? Requirements: 1) Needs to be VBA as I'm looking to utilise the SumColor UDF and obviously CF won't allow this UDF to work. Note: Actual colours not important for basis of enquiry just use, Red, Blue, Green, i know how to...
  17. Rixn

    How to know if a cell have bg color?

    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...
  18. C

    Mark duplicate records with a color

    <!--[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/>...
  19. T

    HELP:Color code values with function in excell

    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 >...
  20. J

    If statement else leave the cell alone

    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...

Some videos you may like

This Week's Hot Topics

Top