conditional format color

  1. J

    Conditional Formatting for Multiple Values (Formula Not Working)

    I have a long list of numerical values in a column and I am trying to set up conditional formatting to highlight cells that contain specific values in blue. The values I am trying to apply this formatting to are the following: 200180, 200181, 200182, 200252, 200940, 200065 After doing some...
  2. P

    VBA: If cell is highlighted, highlight adjacent cell in next column

    Hi all, I am trying to write a script that will highlight the cell adjacent to the highlighted cell. Here is what I have come up with but throws an error: Sub if_highlight() Dim c As Range For Each c In Columns("B") If c.Interior.Color = Excel.XlRgbColor.rgbYellow Then c.Offset(...
  3. D

    Column chart: Assign/derive column colors by/from data values

    Hi, I have a very basic question about plotting data in Excel charts. My data contains two columns representing date and quantity and a third column which contains categorical values (see sample data below). I need to create a simple column chart with date on x-axis and quantity on y-axis and...
  4. S

    Data Validation to VBA

    Hi All! I need to translate the following data validation rules to VBA: Rule 1: Cell does not contain: no blanks format - as white -- stop as true Rule 2: =OR($J3="Pending - Please Elaborate in Notes") as red Both of these formatting rules apply to $K2 through $K1048576 I am...
  5. 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...
  6. U

    Conditional Formatting won't allow font color changes but will allow fill color changes

    Hello all, 1st post here so I will try and be as descriptive as possible. Appreciate any help! I'm using Excel 2018 and I'm trying to get conditional formatting to show an arrow pointing up in green and an arrow pointing down in red. I do not want to fill the cell with color, I only want the...
  7. A

    Conditional Formatting

    I have a spreadsheet where in Column C the CELLs are filled with a mixture of text and numbers. I am wanting he text to highlight in a colour when text is entered and the numbers to remain black. Example Column C3 has Email typed - This would turn red. Column C4 has a number - 1234 - This...
  8. L

    Conditional Formatting for Date and Time in separate cells

    I would like to use conditional formatting to highlight cells that have an actual date and time after the originally scheduled date and time. For example, column 4 row 3, the delivery time is 18 minutes late - I'd like to highlight that. And in row 4, it's a day late, that would also need to...
  9. R

    Conditional Formatting dates

    Hi, I'm wanting to make some dates within a spreadsheet change depending if the date is older than six months (turn red), is two weeks before the six month deadline (turn amber) or is within the six months (turn green). I can get the dates to turn red and green but it is the formula for the...
  10. C

    Conditional Formatting for lowest ten scores

    Hi Guys, I run a few golf pools a year and have a pretty good spreadsheet that automates a lot of stuff (now if only I could tie into alive leaderboard). One of the things people want to see is their lowest 7 scores highlighted. I can total the lowest 7 using the SMALL function, but when...
  11. K

    Help with Multipole Conditional Formating

    Hi Everyone! I am hoping someone can help me here. I am at my wits end with this project. So I have two different conditional formatting by formula rules in place. The first is...
  12. D

    Conditional Formatting Assistance...

    I am trying to assist someone with reconciling all of their business financial information into one excel workbook. It has become a little complicated now that I have worksheets for bank information, time keeping information, and multiple quick book exports. I have noticed that the check...
  13. C

    Conditional Formatting

    I have a sheet that has multiple lines of data and in many cases there are repeated lines because I am linking headers and lines. For example: A B C D E F Contract Customer Name Contract Date Charge qty...
  14. N

    Conditional Formatting Question

    I am working with 3 columns and need the following things to happen: 1) If a cell in column F contains a date, the cell in column G should add 5 business days to this date (due date). Column G should be empty if there is no entry in column F. 2) If the date in column G has passed, the cell...
  15. E

    Conditional Formatting and Negative Numbers!

    Hi! I have what I think should be very simple, but is not working for me right now! I am working on a scorecard sheet. So, we have a number of metrics, and for each we have Target and Goal for every month. Then, for each metric, there is a calculation of the percentage-where are they in...
  16. H

    conditional format color count

    I'm using excel 2013. How do I count the number of cells that have been conditionally formatted to be a certain color and output the result in another cell? I have a spreadsheet full of stock picks. All stocks are displayed in rows 5-50 Different analysts ratings are displayed in columns F thru...
  17. D

    Background Fill portion of Conditional Formats is not working

    The Background Fill portion of Conditional Formats has stopped working. Both the range and the formula are valid because the Bolding of the font and the Underline-ing of the rows work as expected. Only the colored fill is missing. For instance, the CF formula is =AND(MOD(ROW(),3)=0, $A1<>"")...
  18. J

    Conditional Formatting Issue (counting by colour)

    I am using the following website to try and count the coloured cells in workbook (including the code posted): https://www.ablebits.com/office-addins-blog/2013/12/12/count-sort-by-color-excel/ I have conditionally formatted my work, and I can see that it is working (all the cells I want...

Some videos you may like

This Week's Hot Topics

  • Problem in vba vlookup
    Dear All Master, The problem I mean is as follows : 1. I want to modify the vba code because it takes too long/very slow to vlookup in VBA code...
  • VBA Vlookup
    Please for help. Why it`s not works? [CODE=vba]Sub Check_equpment1_click() Worksheets("Production_program").Activate Dim ans1 As Integer ans1 =...
  • Nesting INDEX MATCH into SUMIFS
    I currently have several formulas pulling in a SUMIFS from a data sheet, beginning with =SUMIFS('datasheet'!$N:$N, 'datasheet..... but as I am...
  • Extracting number from a range randomly
    Hello Expert, please kindly advise what is the best method to extract numbers from a range randomly I have a series of numbers in the range of A1...
  • Problem with If Formula
    I am using the following formula in cell A5. I would like if N5 is blank then A5 also return blank. If N5 is 0 or is greater than zero then equals...
  • Is there a way to make the day's name show up automatically in a header?
    I have a form I print out every day..and in the top right custom header I have the &[DATE], which automatically gives the current date in top...
Top