highlight cells

  1. K

    Question about conditional formatting

    I have an excel file with some sort of planning. I can't find some sort of idea on google or this forum if this is possible, so here is my question. The planning is for every month, and every month has 4 rows (see added screenshot). Row 1: Weekday names (in Dutch) Row 2: Weekday numbers (in...
  2. J

    Conditional Formatting for Multiple Values (Formula Not Working)

    I have a long list of numerical values in a column and I am trying to set up conditional formatting to highlight cells that contain specific values in blue. The values I am trying to apply this formatting to are the following: 200180, 200181, 200182, 200252, 200940, 200065 After doing some...
  3. C

    highlight cells more or less than 0.2 to nearest 1

    Hi, is there any way to highlight the cells in a range, if: the value is more or less than 0.2 to the nearest 1 there are already a formula in each of those cells in the range, which will change according to what i change at the other cell. example: if cell value = 6.09, highlight if cell value...
  4. C

    Conditional formatting

    I am trying to highlight rows in if the values in column C and D contain an exact value from column ‘N’. The Values in column are like below: R1179555 R1180259 R1789852 So, if any rows in column C or D contain any of the exact values in column ‘N’ highlight the row. For example: Value...
  5. U

    VBA Search, Replace and Highlight Replaced Cell

    Hi Guys, Can you possibly help me on this? I'm trying to create a macro wherein in Column A, I need to look for these words Football, Basketball & Tennis and will replace as Sports. In column A as well, I need to look for Math and Science and replace as Subject. I have below codes for the...
  6. L

    How do I color format dates in one column into another column

    Hi, New to the forum I'm here cos i'm stuck with a task. I have a spreadsheet with a list of dates and non dates in column A In column B I want to color highlight cells (so that they can be overwritten with other text) I want to show in column B 1) dates from column A that are greater...
  7. A

    Highlight cells between columns if value does not match

    Hello. What I intended is for the cell in Column C to be highlighted if the value does not match with cell in Column D. The cells in both columns are not in the same row, so to know if it is matched is with respect to Column B and Column E. (i.e.C6 will be highlighted but C5 will not be...
  8. K

    Highlight cells

    Originally Posted by kamranyd View Post Code: Attn_Name = .Range("B13") If Len(Attn_Name) = 0 Then MsgBox "Please enter receiver name", vbCritical, "Quotation Receiver Name Error" Range("B13").Activate ActiveWindow.ScrollRow = 13 Exit Sub End If...
  9. T

    Help! Conditional formatting or "if"

    Please help! i have a spreadsheet i put together for a Manager (see below) Each column (H,M,R) represents locations on a job we need to close out. I used "CONDITIONAL FORMATTING" > HIGHLIGHT > DUPLICATES"..... showed to my manager, he loved it and wanted to know if we could highlight the...
  10. V

    Keyword search - Highlight Results - Hide other rows

    Dear Excel Experts I adapted a conditional formatting Macro for my purposes. It works now with an inputbox quite neatly and highlights the cells where the keyword is found. However, I want to hide the other rows where the keyword isn't in. I don't know if that's even possible with this code...
  11. C

    Highlight 3 or more consecutive blank cells in a row but not 2 consecutive or less

    Hello guys, I am using a time keeping file I need to monitor daily and make sure the team is recording their time in the office (company policy). The team is working 7 days per week and we have 2 consecutive free days (blank cell in time keeping). Theoretically there should never be 3...
  12. DPChristman

    Conditional Formatting in burst reports

    I have a large report with about 300 districts on it. Each week, this report is burst out to the field, with each district getting only their stores. I do not do the burst (don't know how, to be honest), so I didn't realize this was happening When the file is burst out to the field, the...
  13. E

    Excel VBA. Highlight cells based on criterion

    Hi! I’m trying to find a simple solution for my Excel VBA script. Sorry for my bad English in advance..:) There is an excerpt from my code. Sub TEST() Range("E2").Value = Application.WorksheetFunction.CountIfs(Range("G4:G1000"), 100, Range("J4:J1000"), ">0") End Sub It puts (in E2 cell) an...
  14. J

    VBA help with an on the go formula for a group of cells gets highlighted.

    Basics: The column letter is static (something like column NX:NZ); the numbers of rows for a group can change. The math I want to perform would be positioned differently for each group. Details: I have data like the seen below – my sample shows three groups of various lengths, with one or more...
  15. L

    highlight a cell if it does not contains one of three letters

    Hello, I'm trying to find a way to highlight cells that do not contain either a y, n, or o. I've tried conditional format but can seem to figure out how to have excel search for all 3 letters. thanks
  16. A

    Display highlighted cells dimensions

    Hello, We are working on a warehouse layout, which has huge floorspace, using excel spreadsheet. the layout scale is good enough to represent each square cell as One Square foot. We're trying to measure certain areas by highlighting group of cells, no matter if they contain values or blank...
  17. C

    Excel automatically highlights row and column number when you click on a cell. How can I get excel to highlight a cell(s) in the same column and row a

    I am creating a spreadsheet for my job and it would be really helpful if somebody knew a code or any way to implement this into my spreadsheet. Thank you, Chris
  18. C

    need a cell(s) highlighted when clicking on another cell in the same row/column

    Hello, I am working a spreadsheet for my job in which I need certain cells in the same row/column to be highlighted when clicking on another cell. For example, if I click on D9, I want cells B9 (same row) and D1 (same column) to be highlighted a given color. I want this same rule to be...
  19. C

    Looping array to highlight / colour sequential zeros

    Hello, I have 4 columns with data H, I, J and K. I need to write a macro that will search through H, starting at H14 and look for a single 0 (zero) in all cells with data in column H starting from H14. This is where I get a bit stuck as I don't know how to add IF functions through arrays. So...
  20. E

    Sum in different sheet in Excel 2013

    Hi all, Hopefully there is an easy fix for this! I 'upgraded' to Excel 2013 today and I have noticed that when I am doing a SUM or SUMIF etc in one sheet or workbook where the array is in a different tab or workbook, Excel no longer highlights the cells I am selecting, so it is relatively...

Some videos you may like

This Week's Hot Topics

  • Problem in vba vlookup
    Dear All Master, The problem I mean is as follows : 1. I want to modify the vba code because it takes too long/very slow to vlookup in VBA code...
  • VBA Vlookup
    Please for help. Why it`s not works? [CODE=vba]Sub Check_equpment1_click() Worksheets("Production_program").Activate Dim ans1 As Integer ans1 =...
  • Nesting INDEX MATCH into SUMIFS
    I currently have several formulas pulling in a SUMIFS from a data sheet, beginning with =SUMIFS('datasheet'!$N:$N, 'datasheet..... but as I am...
  • Extracting number from a range randomly
    Hello Expert, please kindly advise what is the best method to extract numbers from a range randomly I have a series of numbers in the range of A1...
  • Problem with If Formula
    I am using the following formula in cell A5. I would like if N5 is blank then A5 also return blank. If N5 is 0 or is greater than zero then equals...
  • Is there a way to make the day's name show up automatically in a header?
    I have a form I print out every day..and in the top right custom header I have the &[DATE], which automatically gives the current date in top...
Top