conditional format

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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