conditional format

  1. D

    Change borders/gridlines of cells in rows A, B, C & D when cells in row E contains no blanks

    Hello everybody, I am currently sitting with the following material overview file in Excel: I have made some conditional formatting so whenever I enter a number in column E the entire row gets highlighted. Unfortunately, this erases/makes invisible my dark gridlines/borders from before...
  2. L

    Conditional formatting help!!

    I have a table with a "DATE" column that I generally update daily with the current date, so my current conditional formatting for that column is - Cell Value < TODAY() - (with a green colour), so if the date is from yesterday or beyond then it will highlight green until I change it. But I have 2...
  3. R

    Conditional Formatting and Percentages

    Hi All, I have a spreadsheet which, in column L there is a percentage that is based on the numbers in columns D and G. I would like to create a conditional format that says: -if column L is less than or equal to 3% format the entire row green -if column L is between 4 and 6% format the entire...
  4. freelensia

    Excel: cannot change alignment of a cell under conditional formatting

    Hi, I have a structured table with a certain table style: All of the cells in them are also formatted as "Normal". However my "Normal" is slightly different. It has cell background as white (not no-color), and has alignment OFF. Furthermore, in column Good Listings I have some Conditional...
  5. H

    VBA How to add conditional formatting with graded color scale?

    Hello Excel experts, I'm struggling with adding something like conditional formatting in VBA: the lower is the number, the greener must be the cell (like built-in Excel conditional formatting). So far I was able to find and modify the following VBA code, but it crashes on the following line...
  6. M

    Altering conditional formatting macro to work across different worksheets

    Hi there, I have a conditional formatting macro that works well comparing lists of non-matching data on the same worksheet. What it does fail to do is to also compare data lists on two different worksheets. Is there a way to adjust the code so that it handles selecting data from 2 different...
  7. M

    Help fix my conditional format macro

    Hi there, I am just after a little help to finish my attempt of automating a conditional format that I use often. I use it to check to different columns of data to see if they are identical or not. This is my code below. Sub Conditional_Formatting_MatchData() Dim rng1, rng1a, rng2, rng2a As...
  8. J

    Conditional Formatting - Date

    Hi all, I tried to use the Conditional Formatting function to filter out the dates that occurred before 2020, my column contains cells along the lines of 11/01/2019, 21/09/2019, 21/11/2020, 01/05/2020 etc. As usual, I followed the HOME > Conditional Formatting > Highlight Cells Rules > Text...
  9. 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...
  10. dreen

    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...
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. 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...
  16. 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...
  17. 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...
  18. 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...
  19. 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...
  20. 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...

Some videos you may like

This Week's Hot Topics

  • Finding issue in If elseif else with For each Loop
    Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
  • MsgBox Error
    Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
  • CELL FORMAT - IF CONDITION
    My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
  • Show numbers nearly the same
    Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...
  • Please i need your help to create formula
    I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
  • Got error while adding column and filter
    Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...
Top