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

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

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

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

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

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

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

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!

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

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

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

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

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

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

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

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

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

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

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

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