condional formatting

  1. R

    dependent cells to follow decimal formatting of parent cell

    Hello, New to this forum, I thank you for your help in advance. I need dependent cells to follow the decimal formatting of a one parent cell. I've done this with format painter but my parent cell decimal requirements changes from time to time and I need the dependent cells to adjust and...
  2. L

    Conditional Formatting: can't highlight all duplicate instances

    Hi everyone. I've got a formula that's supposed to highlight every duplicate in a column, except for the "F" character. My problem is that only the first instance of a duplicate value gets highlighted unless I type the COUNTIFS range as an absolute reference and I don't get why. The reason I'd...
  3. Z

    Conditional formatting cell based on the value of the adjacent cell

    I have tried everything I have found on conditional formating and I can not get it to work. The data in my cells is generated for formulas so I don't know if that is the problem. I would like to highlight column B based on the value in column C. If Column C is less that 1 or equal to Zero the...
  4. L

    VBA Conditional Formatting

    Hi, Thanks again for taking time to look at this. What I am trying to do is change the colour of the above cell depending if an S is in the below cell. I already have a vlookup formula in the above cell which depending on the value will change colour. This is easy to do with conditional...
  5. S

    Conditional Formatting Formula

    <tbody> JUL AUG SEP OCT NOV DEC FIELD 1 FIELD 2 FIELD 3 FIELD 1 FIELD 2 FIELD 3 FIELD 1 FIELD 2 FIELD 3 FIELD 1 FIELD 2 FIELD 3 FIELD 1 FIELD 2 FIELD 3 FIELD 1 FIELD 2 FIELD 3 -500 -350 445 -525 -357 225 -285 -337 235 -288 -275 225 100 125 25 75 150 70 250 225 25...
  6. M

    Help fixing my AND/OR formatting rule

    Hi, I am just after a little help in fixing a formatting rule that I have written as a conditional format that I have written for QA work. Here is the code I have written: =OR(AND(SEARCH("missing",K1),M1="No"),AND(SEARCH("lost",K1),M1="No")) Basically I want the format to highlight when a...
  7. H

    More conditional formatting

    I also have another problem with conditional formatting. When I put the following formula in to determine which cells to format it then changes my N/A (from a previous conditional format) to that particular colour too. For this I used the following formula: =IF(AND(b1<=TODAY()-1642,b1>1),TRUE)
  8. R

    Conditional Formatting not being copied when new row is added to a table

    I have some code that creates a new line in 3 different tables on three different worksheets in a workbook when data submitted through a user-form. All of the formulae are copied from the line above and all of the data from the user-form writes to the correct locations, but I have a total of 5...
  9. J

    Data Bars not showing on Dashboard

    Good Day I am using a spreadsheet with some tabs that are published as web pages so that we can display them on TV`s as dashboards. In one dashboard we have some targets, I am using the data bars from conditional formatting to gradually color in the cell as we progress. It works great however...
  10. O

    Cells that automatically change color

    Hi ! I was wondering if anyone could help me. I have provided an image, so illustrate what I mean. As you will be able to see I have a column labelled PM - this column has the initials of project managers. When I enter the initials it will automatically fill in a color. This has been...
  11. P

    VBA apply conditional formatting to cell which currently have fill

    Hello, I am using VBA to apply conditional formatting to a column however, I only want the conditional formatting to be applied to cells which already fill in them and skip any cells with no fill. Below is my current code. Sub ApplyBAandCertConditionalFormatting() With Sheet2 With...
  12. N

    Button to change formulas - Filter 3, 6 and 12 months next to This months orders column.

    Hi All, Probably the hardest thing I've had to do in excel and I need someone with a better skill set than I currently have please! I've put together a pretty big spreadsheet which draws data from ODBC links to a database. Part of the report shows how much has gone out over 12, 6, and 3...
  13. E

    Match/Index IFBLANK Conditional Formatting

    Hello Everyone, I searched everywhere and I can't seem to find the answer to my problem and to be honest i don't know if this is even possible. I run a huge family "NFL Pick the Winners" spread in Excel, about 18 of us. I was hoping I can use conditional formatting to change the color of...
  14. D

    Conditional Formatting Cells X amount of minutes to previous cell

    Hi Everyone. I am trying to create a worksheet that highlights SLA acceptance and breaches. In Column F, I have the time an Incident is received e.g. 16:05:00 In Column G, I have the time I accepted that incident e.g. 16:10:00 I need the cells in column G to highlight Green if it's within 15...
  15. T

    Conditional Formatting text colour based on day of week

    Hi there, I'm wondering if there's a way that I can format the text of a sheet so that it will automatically have a specific color relating to the day of the week the text is entered? For example, if I enter the text on a Monday it will be green, if I enter it on Tuesday it will be red, etc...
  16. M

    Formatting Cells included in SUMPRODUCT

    I am using the following formula to find the total of the 6 largest values in a range of cells... =SUMPRODUCT(LARGE(B45:B54, {1,2,3,4,5,6})) The function is working exactly like I want. However, now I would like to create a conditional formatting rule for that same range of cells so that if a...
  17. W

    Chart conditional formatting, VBA

    Hello)) I am trying to conditionally format my chart. I know that I can do it with "IF" statement (which I do successfully). But I want to format the fill color of my chart bars based on the cells' color (bars take the same color as cells). Something tells me that there should be an easy VBA...
  18. N

    [Excel 2010] Formatting calender depending on list of dates

    <tbody> dates M T W T F S S 01/27/2017 16 17 18 19 20 21 22 01/28/2017 23 24 25 26 27 28 29 01/29/2017 30 31 1 2 3 4 5 02/02/2017 6 7 8 9 10 11 12 </tbody> Hey! All I want to do is to highlight every day in the primitive calendar on the right that is stored on the left in the...
  19. I

    Comparing data between sheets using Macro or something similar

    Hello, I need help regarding Excel formulas or Macros. It's kinda complicated so I will explain it. I'll post the Excel Template tomorrow as an attachment since my collegue who creates the Excel is not available by now. This Template has fictional employees. On the excel you can see 3...
  20. K

    Help with deleting columns based on conditional formatting please

    I have a spreadsheet with 72 rows and about 10,000 columns. I have applied conditional formatting to highlight all the cells which have a value of less than 150. Is there a way of now deleting all the columns where ALL the cells are highlighted/less than 150? At the moment I have the cells...

Some videos you may like

This Week's Hot Topics