conditional formatting

  1. B

    VBA - Amend Conditional Formatting

    Hello, I have an excel 2013 template that is sent to me every month from another department - there are some manual adjustments that need done to the workbook before I send it out and I have written a simple macro which does this for me. The only thing I cannot get to change is some...
  2. S

    Is it possible to make pivot table with "%difference to previous" Grand totals with arrows?

    Hi guys. I am building a Pivot which will grow with data each day. I sorted the refresh with VBA, and I did setup my value fields to show values as % Difference from previous day. What I couldn't figure out, how to create a conditional formatting that will add those up/down triangles to my...
  3. N

    Conditional formatting highlighting duplicates

    Hello, I am working with a data base of addresses which I am trying to find duplicates in from new data coming in. I would like to be able to have the data base data in Sheet 1 and the new data in sheet 2. And reference those against each other (both sheets get highlighted). The addresses...
  4. O

    Highlight cell if value higher

    Hi, I'm trying to compare two columns. When the value in column 2 is higher than in column 1, I highlight the cell. I've selected my first cell (let's say B1) and went to Conditional Formating > Highlight Cell > Greater Than and selected my first cell from my first column (A1). Now, I need to...
  5. 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...
  6. M

    How can I highlight cells that have been changes since "X" date ?

    Hello! I have a mega forecast that people update and I'd like to make it simple to see which cells have been updated (could be added as a new line or info deleted or changed in a cell). The model already has lots of conditional formatting indicating various things so it needs to work on-top of...
  7. S

    Conditional Formatting of Partial Data

    I’m looking for help on how to conditionally format several worksheets in a workbook. Each worksheet already has a different type of conditional formatting in areas that I would not want affected by the new conditional formatting. I have two columns (A and B) with approximately 50,000 cells...
  8. C

    ActiveCell.Interior.Color is NoFill but returning 16777215

    I have some cells that are formatted as the basis for conditional formatting. My VBA code looks at those cells formats and assigns the values to variables I look through each cell and apply the basis formatting to a range. Some cells I have a set to No Fill and that's visible on the cell as I...
  9. T

    Cell format overrules conditional formatting

    I have formatted cells using conditional formatting based on a given value in my workbook being equal to either "EUR" or "USD". The custom format it should get when "EUR" is: "€"#.##0,00 (see screenshot 1). It shows the correct format (see below image), however when you would paste this cell...
  10. C

    VBA - Copy Cell Formatting to Conditional Formatting of Range

    I have a number of reference cells representing the working duty names an employee may be rostered to work. (e.g L, B, AD, OH, AL, etc.) These cells are static and used as a reference for available duty names but are also coloured & formatted (including bold, italics, etc.) to allow them to...
  11. 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...
  12. C

    Multiplication Based on Cell Color

    Hey all! Hoping someone here is a bit smarter as I've ran into a mental roadblock. My Worksheet: I have a inventory worksheet with 4 columns (ID, Product Name, QTY, Total Price) and 788 rows. We are offered pricing based on the "QTY" column, for example 1-10 is $55.00, 11-50 is $25.00. I will...
  13. Z

    Conditional Formatting Formula

    Hi everyone, I hope you can help me with this. I am looking for a way to apply a conditional formatting in Column A to highlight second and onward occurences of number strings. These numbers can be preceded, in between or followed by text characters. I almost got it with the second formula...
  14. B

    Conditional Formatting Data Bars - Adjacent Cell

    I would like to create a conditional formatting data bar next to the cell with the value. For example, if cell E1 is -250,000 then cell F1 will be red and if cell E2 is +125,000 then cell F2 would be green. I would like this to be on a gradient as one can accomplish in a data bar within the...
  15. B

    Conditional formatting in VBA

    Hi, I have one question: I am trying to figure out how to add to the middle of my recorded macro part that will take a kid name from user and mark it green in the whole spreadsheet. I have tried the code below, but it doesn't work (error object required). Name = InputBox("Enter Kid's...
  16. L

    True or False statement using the AND function

    I ran into a speed bump yesterday and today with a true or false statement from data in a single column containing a speed (see attached picture). Most, if not all, speeds are two digits in length; however, yesterday and today I had several speeds post in single-digit format (i.e., 3, 6, 8...
  17. J

    Auto-expand conditional formatting range to include new columns/rows

    I like to apply conditional formatting when tracking metrics to quickly identify things such as top and bottom 3 months of performance, however, whenever I add a new month (typically as a new column) the formatting does not include the new data, so I need to manually change the Applies To range...
  18. B

    Specific text conditional formatting

    Hi Everyone, I've made custom sheets and I decided to add a post validation process to a column. My plan is use formula isnumbersearch to look for specific cells having "001" within them. This is all within the same workbook; I'd like to from this sheet(Sheet2) have conditional formatting that...
  19. S

    Highlight Cells Outside of Data Validation List

    Hi! I have a spreadsheet with a Data Validation column referencing a range on a separate sheet. What I'd like to happen is to highlight any cells not meeting that criteria. I know it throws the Data Validation error, but I'm having trouble getting people to understand I can't work with data...
  20. S

    Conditional formatting based on whether a specific sheet name is present

    Hello, I have a series of specific templates that are being added to a workbook. I would like to highlight a cell in the first sheet of the workbook if the workbook currently has a worksheet by that name present. For example, if I add a template named "Saturday" to the worksheet, I would like...

Some videos you may like

This Week's Hot Topics

Top