color cell

  1. G

    runtime error 9 - Subscript Out of Range Error or runtime 1004 - method 'range of object' worksheet failed when trying to color cell

    Hi, I have a vba code that is intended to highlight cells based on value of the cell i.e. if it is empty. The code identifies the cell values correctly but it will not colour the cell. I keep getting an runtime error 9 - Subscript Out of Range Error or runtime 1004 - method 'range of object'...
  2. K

    Expense Report Formula Help

    Hey yawl, I'm not very advanced with Excel so I apologize if this is a silly question. I'm building an expense report that I can drop each months expenses in. I have it set up to color coat each purchase depending on what category I want them to fall under. I was wondering if there is a...
  3. M

    Change color based if cell another sheet are not empty

    Hello, I am trying to make a cell change color if a range of cells on another worksheet are not empty ie cell on worksheet TEST1 that need to change color is E3 and have to check if a range of (lets say B2:C10 cells on Worksheet TEST2 are not empty. Can this be done with conditional...
  4. S

    How do I cause excel to skip number sequence using colour?

    I have an example I would like to make a reality with a formula for Column C. In Column B, I have used a formula to create a naming convention using Column A (check the formula bar in the picture above for reference). Column C is what my desired result should be at the end. I have just typed...
  5. 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...
  6. 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...
  7. 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...
  8. 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!
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. 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 =...
  16. 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 =...
  17. 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...
  18. 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...
  19. 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...
  20. 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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back