conditional format

  1. X

    Special Conditional Formatting for multiple numbers

    Greetings, I've searched throughout the forum and haven't been able to find anything remotely similar. Basically in Column $B:$B I have multiple aircraft tail numbers. I.e., ACFT 133 135 146 149 152 I'm going to have 2 separate Conditional formats. The first is going...
  2. D

    Using VLookup with Conditional Formatting when Inserting a New Row

    I have two sheets and I am trying to re-apply the conditional formatting to Sheet 1 (Test 1) whenever a row is inserted into Row 2 of Sheet 1 (I have made my code apply the conditional formatting whenever Cell A2 is changed). For the conditional formatting, I want to check if each visible cell...
  3. S

    VBA Less than formula

    I have a warehouse mod to be completed and ive created automatic or Userform activate that when a order line is in the negative it needs to be highlighted in Reg The formula I got is: Private Sub Reg6_Change() If Sheet12.Range("H6").Value < Sheet12.Range("K6").Value = "0" Then Me.Reg6.BackColor...
  4. A

    Conditional format on multiple cells color/colour

    Hi, I have and excel sheet and I have several cells which have conditions set and change color/colour dependant upon the drop down list, but I need a cell to change upon the colour / color of the other cells (Overall) - so if :- No Red subcategories and no more than one Yellow subcategory...
  5. T

    Conditional Format Data Bar 2 Colours Based on Number Range

    I have a column in excel that has been formatted to display a progress bar based on the value in the cell 0 - 100. I did this by going to: Home > Conditional formatting > Data bars > More Rules: Then I select, Format Style: 'DataBar' / Type(min/max) 'Number' / Min Value: 0 Max Value:100 This...
  6. D

    Conditional Format based on time difference

    <tbody> Employee ID Name Start Finish 161 Paul 10/08/2019 23:00:00 11/08/2019 06:00:00 100 Fred 10/08/2019 23:00:00 11/08/2019 06:00:00 224 Jane 11/08/2019 10:00:00 11/08/2019 18:00:00 100 John 11/08/2019 15:00:00 12/08/2019 03:00:00 161 Paul 11/08/2019 16:00:00 12/08/2019 02:00:00...
  7. K

    Conditional Formatting & Subtotal Macro

    Hi All, I am trying to build a conditional formatting macro at the end of a string I already have that will help visualize the data represented. The data is located (A12:V750) but the conditional formatting will apply to Column F (I am hoping to have the highlighting apply to the whole row...
  8. O

    UDF Error with automatic calculations

    The formula below is being used in a table to see which cells in the range have a particular conditional formatting color. When I enter the formula in the first row and excel auto-fills the other rows, the formula works. If I turn on automatic calculations, it gives #Value !. If manual formulas...
  9. S

    Copy / paste actual interior color

    Hi, I need to copy the conditionally formatted cells and paste format to a new range. Currently I do: Workbooks(EnvelopeFile).Worksheets("System Envelopes").Cells.Copy Sheets(xlSheet.name).Cells.PasteSpecial Paste:=xlPasteValues Sheets(xlSheet.name).Cells.PasteSpecial...
  10. S

    Conditional Format with multiple dates in one cell

    Hi All, I am trying to (easy part) conditional format a column of dates to highlight past dates. <today()" <today(). Easy enough when they contain just one date, however some contain multiple dates - e.g. Column A <tbody> A = 01/04/2019, 13/03/2020, 13/03/2020, M = 06/12/2019 26/10/2018 A...
  11. H

    Problems with offsetting loops on excel vba

    Hello everyone! I have a small piece of code that will be used to compare a column (D) with the values of columns A B and C. It will later compare the column E with B and C. One of the objectives is to compare each cell from D and E with the correspondent cells in A B and C. Example: If D1...
  12. C

    Conditional Formatting Based on Another Cell Color

    Hello! I'm trying to find a way to set a Conditional Format for Column A based on text or color of another cell range. More specifically, my target range is $A. If $B through $H is either grey (it would be grey based on other set Conditional Formats), or contains an "X", I want Column A to be...
  13. D

    Colour Entire Table Row Based on Values in Two Cells

    Hi Folks, I haven't had a chance to use VBA in quite awhile and so I've fallen out of practice. I have a worksheet with 17,000 rows (growing by approx 1000 a month) and conditional formatting set to change the fill colour of some rows (entire table row) based on the values in column 12 and 13...
  14. S

    Pivot Table Macro

    Hi! I have created a pivot table that shows customer in column A, then the sales and sales difference in percent in the following columns by month. So column B & C are grouped under January with actual sales and percent difference from previous month (since there is no previous month, it is...
  15. N

    Conditional Formatting

    I want to utilize conditional formatting and need assistance with a formula to use in it. I want it to turn the text in cell M16 bold, red, italic if any of column M equals less than its corresponding line in column F. I know how to write a formula for one cell but not for a whole column. For...
  16. D

    Automatically SUM Active Cell With Value in Another Cell Google sheets

    I am trying to set up a conditional formatting rule that will automatically SUM the value I input into the conditionally formatted cell with a number from an adjacent cell. For instance, if I apply this conditionally formatted rule to M1: =SUM(K1,M1) I would like whatever number I input into...
  17. F

    Identifying duplicate values in a range based on another criteria of duplicates

    I am trying to find a formula that allows me to do the following in order: 1) If the group ID is the same AND (2) if the Part # is the same as the (3) Part # with the minimum group price, highlight this. For example below, I want to highlight part # MPN1 because it is has the same GroupID and...
  18. F

    Conditional Formating Excel Table

    Hi. I would like to have conditional formatting done on an Excel Table based on the MIN and MAX values of every row in the table. Cells of the MIN values are to be highligted in RED with WHITE font. Celss of the MAX values are to be highlighted in GREEN with WHITE font. I was able to find VBA...
  19. A

    Weekly Planner- conditional formatiing

    Hello, I've created a weekly planner for revision, it has a start date, duration and % completed. The dates are in columns eg 29/03 am and 29/03 pm... It's all great when i enter the duration as 1 day and it highlights both AM and PM for that day. Can anyone tell me what is the conditional...
  20. C

    Conditional format date if it matches two conditions

    I have searched the web for a solution to my question with no luck. Here is my issue: I have cell A1 with a date (any date), I also have two named ranges. One named Holidays and the other one named Payroll. They are used to identify the company's holidays and the payroll dates. I need to...

Some videos you may like

This Week's Hot Topics

  • help please
    SORRY NOT ANY GOOD AT EXCEL SO HELP WOULD BE MUCH APPRECIATED this formula is in a sheet called ignore...
  • two formulas needed
    Hello, I'll try my best to explain this: First formula needed in Sheet1 cell A2: If Sheet1 cell B2 = Sheet2 cell B2 then return a 1. If not then...
  • Dynamic Counts
    Good afternoon, we are tidying up some data & the data seems to be growing quicker than we are tidying it up! What we confirm (by reviewing it...
  • Help Excel formula eliminate duplicate values and keep only 2 identical rows.
    as picture below column A has a duplicate value. but the values are not the same as the rule. sometimes 4 rows, sometimes 10 rows or 7 or 9...
  • Macro Compile Error Sub or Function not defined
    Hello, I am trying to run macros from a validation list, all macros have been created and run perfectly on there own but I'm getting a compile...
  • Last row combined with Current Region VBA
    I'm generally happy finding the last row of data through something like Lastrow = Cells(Rows.Count, "D").End(xlUp) but I don't always receive data...
Top