condtional formatting

  1. M

    Formula used to conditional format rule

    Hi there, I am looking to incorporate the below rule as a conditional format rule - use a formula to determine which cells to format. =IF(M2="","",IF(LEN(M2)>12,"Issue","OK")) Do I need to create two rules essentially to replicate this here? Or how do I amend this rule to "Format values...
  2. M

    How to pastes row of data into another sheet while removing blank lines?

    Hi, I've used conditional formatting on a large set of data to highlight a specific criteria. I have then got formula which gets the highlighted rows into a separate table but the gaps are still there. I was wondering if i was possible to use formula to paste in the rows into another sheet but...
  3. K

    Conditional formatting formula for empty cells

    Hi, i have a range OF CELLS that MY USERS need to fill with data. THE RANGE IS from A1:A1000. sometimes they skip rows for example they fill the cell A1 and then they skip CELL A2 AND LEAVE IT BLANK and THEN THEY fill A3. I need a CONDITIONAL FORMATTING formula to fill in yellow all those...
  4. H

    conditioning in excel based on function

    Hi I’m trying to use conditioning in excel as following If the values in column (cost price) is <$49.99 then write down $4.99 as shipping price If the values in column (cost price) is >$49.99, then write down $0.00 as shipping price Applies the rule to the other rows Thank you...
  5. M

    Conditional Formatting VBA Font Type

    if Column C contains "QC SDMA Feline" I would like the font type of Column B to change from Calibri to another font type such as Arial Black. I am thinking I would need some sort of VBA to accomplish this? I am using Excel 2016 and relatively new to using VBA.
  6. J

    Conditional Formatting -- "Applied To" Keeps Changing

    I've searched the stickies and FAQs and haven't found anything -- after 20+ hours of dedicated research I HAVE to ask you folks how to do this... I have ~10 conditional formatting rules applied on a worksheet. Nine apply to Column H and the other to Columns A-N. If I ever copy and paste ANY...
  7. D

    Can I use conditional formatting to highlight where a cell has been changed (e.g. from N to Y)

    Hi all, I have an Excel spread sheet setup to display departmental compliance with certain criteria, and at the moment I have conditional formatting to show the cell as red when it contains "n" and green when it displays "y". What I would like to do is show also when a cell has been changed...
  8. E

    Help with Conditional Formatting!

    Hi, Hope you can help! I am trying to simplify producing Rotas at work. What I have done is create a lay out with drop down lists refering to the staff. However some staff have different conditions, breaks etc. What I would like is to have the staff formatted in colour depending on what pool...
  9. T

    Color Coordinate Calendar

    Hello, I have an excel workbook with two worksheets. - Worksheet "A" is simply a full calendar for the year, showing each month and day. - Worksheet "B" is our PTO schedule for 5 different employees, with columns showing the following data, starting on column B: PTO Dates <tbody> From To...
  10. J

    VBA count number of cells that have been conditionally formatted

    I have a few conditional formats that, when triggered, format the cell like this: Range("K2:K20").Select Selection.FormatConditions.Add Type:=xlExpression, Formula1:= _ "=AND(OR(RIGHT($C2,2)=""PT"",RIGHT($C2,3)=""SAL""),VALUE($K2)>0)"...
  11. H

    Output based on rows of data that ends with another columns condition

    Hello, I was hoping to get help on this simple output. I just haven't used excel in so long I've forgotten it all. Basically, two columns outputs on the same row an ID exists are created, but only utilise the data in rows of another column up until an ID is listed...
  12. T

    Conditional Formatting

    Hello, I have a WORKDAY.INTL function that returns a due date given parameters (thanks DRSteele). Now I am trying to conditionally format the cell so that the default return date (Wednesday February 29, 1900) is invisible. I have tried conditional formatting as a date, as number, as text will...
  13. F

    Using Index and Match in Conditional Formatting

    I am trying to find a solution to colorize referral cells using conditional formatting. I have two worksheets listing names in columns and dates in a row. The names are not sorted the same way in the different sheets. I want one cell in one sheet to colorized if a correlating cell with...
  14. andrewb90

    Add column to Row highlighting VBA

    Hello All, I have this code that I am using to highlight rows, I have been trying (unsuccessfully) to have it highlight the column (Row2:20) as well. Can anybody help? Option ExplicitConst MyAreas = "C2:S14" Dim a, MyCol As Collection, Rng As Range, x As Range ' Highlighting with...
  15. P

    What to do IF need a cell to be highlighted in red, if multiple cells in another worksheet contain anything

    I need to a cell (D3) on work sheet "Year Summary" to be colored red only if any of the following cells (C3:P4) contain anything (letters or numbers) in Worksheet "Jan 1-3". I tried conditional formatting but pretty sure not using the right formula because its not working properly. Please...
  16. ChrisUK

    Conditional Format - using a formula

    Hi, I have a large sheet with a selection of cells with a validation list in each cell (Yes,No,Maybe). Depending on the cell value I have a conditional format set of Green, Yellow or Red. So far so good However, I have inserted a new column at the start of the sheet now where the cell value...
  17. E

    Conditional Formatting of a scatter graph

    Hi All, Thanks for checking this post, and thank you even more if you can help! I've had a search and found nothing the same as what i need to know, apologies if this has already been asked. I'm seriously stuck and in need of help, I need to plot a heatmap of data based on geographical...
  18. H

    Conditional Formatting

    Hi I am trying to conditional format a cell but am struggling I have a summary sheet, which I would like to autopopulate based on data on other sheets in the workbook I would like Cells A15 and B15 on Sheet A to conditonal format to green, if the there is no data in column M on Sheet B. In...
  19. C

    Button Press for Condtional Formatting Based on Cell Values

    Good day, I'm using Excel 2010 and creating what is essentially a study tool - a comparison between two lists (one that the user populates and the one beside it which has the answers). There are three columns in each list but there are merged cells that serve as headers for each sub-section. I...
  20. J

    Need Formula / Conditional formatting - Dates

    Dear All, I have a data file in which i have two column, 1st is Expiry Date column in which past, present and future dates are mentioned and 2nd is Status column in which user will mention status either "OK" or "Pending". I need a formula / conditional formatting which will start highlight (...

Some videos you may like

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top