conditional formatting

  1. N

    Help with excel formula / conditional formatting

    Hello, I am trying to find a way to do this: If F2 says 'Card' and then I2 has data in it, turn the line green, if F2 says 'PO' and I2 has data in leave the line orange and then if F2 says 'PO' and both I2 and J2 have data in turn the line green. HELP PLEASE!! Thank You
  2. B

    Is Conditional Format Bold Really Bold??

    I have been looking at Excel Magic Trick 1355 and want to create a similar result. However due to some original data issues, I am having to conditionally format my data column to make the "Parents" bold rather than manually converting them to bold. As a result the IsBold function I created with...
  3. L

    Copy formatting from a Range to a Cell via Drop-down list

    Hello Guys, I've been browsing for a while now and can't make it work. I've seen all the steps i need made on different threads but i can't join them due my lack of VBA syntax knowledge. Therefore I'm looking for help in the forum that helped me the most!! I have a user colored dynamic range...
  4. S

    conditional formatting in vlookup

    conditional formatting is reading the text in vlookup and changing colour it should not happen. =IFERROR(IF($B7>0,VLOOKUP($B7,DATA_BASE!$A$2:$B$100000,2,FALSE),""),"NOT FOUND IN DATABASE") Range("J2").Select Range(Selection, Selection.End(xlToRight)).Select Range(Selection...
  5. R

    Automatically change number color based on +/- within text string in one cell

    Hello! I have a tried multiple different solutions but have not been able to make this work yet (including trying to write a VBA code) I am trying to change the color or negative numbers to red inside a cell that also contains text/other formulas. This was the latest and what I thought would...
  6. S

    Conditional formatting for individual subcategory ?

    Is it possible to automatically apply data bars to pivot table like this? As you can see there are individual data bars for every subcategory (dates) , and they are not related to each other on category level (item) To make it more clear on what I mean, here is how it would look like if I used...
  7. M

    Re-Initialize Conditional Formatting Array Formulas (50+ Rules/Columns)

    Hello all! I have a workbook with multiple tabs (such as "MF1 - Employee Data") that acts as a template for clients to place their employee data into. Also in this workbook is another tab (Validation Data) that contains all of the configuration/build details of the client's environment. The...
  8. I

    Conditional Formatting BASED on range of cells

    Hello, I have a list of dates in a column (say A1:A20) I have list of holidays in another column (say B1:B10). I want to highlight the cells of column A, if any of them match column B. In short, I want to highlight all the holidays in my master date list. Conditional formatting allows...
  9. T

    Conditional formatting a highlight a row with 2 conditions, one being a date

    What I am looking to do is, to highlight a row when 2 conditions are met. one of the cells is formatted as a Date (00/00/0000). The worksheet is set up as a tool log with many tools listed each on their own row. When someone checks out the tool there name is entered in the same row the E column...
  10. J

    Removing duplicate values in multiple columns

    I'm wondering if theres a way that I can remove duplicates or apply conditional formatting to columns where the values in two columns are identical to those in another row. For example, I would want the formulat to be able to identify that A1 and B1 were identical to B1 and B2. However, it...
  11. K

    Conditional Formatting Borders

    I want to set up conditional formatting so that if a cell has data the entire row will automatically get borders. The possible columns that can have data are A:E. The rule I am using is =OR(A1<>"",B1<>"",C1<>"",D1<>"",E1<>"") and applies to =$A:$E. This mostly works but if for example only cell...
  12. A

    Filling cells based on a pull-down

    Hi everyone! I have a spreadsheet we want to use as a sort of fillable form for non-tech savvy people to send us data in. The problem is, there are columns they don’t need to fill in depending on which one of several dozen selections is made in a different column. The original solution to this...
  13. M

    Conditional Formatting to change the Fill color of a cell based on the hex value of a different cell.

    I have a block of cells A1:D4. I want to set the fill color of that block based on the value of cell F1, which should have the form #XXXXXX, where “X” is a hexadecimal digit. And as I change the values of cell F1 the fill colors change as well. Is this possible? I tried conditional formatting...
  14. A

    Conditional Formatting - Icon Set

    Good afternoon everyone, I'm thinking this is an easy question but I'm having a brain fart and can't figure it out. Basically I have a spreadsheet where I need to have a red light whenever the percentage is less than -8% and a green light whenever the percentage is more than 8% and have no...
  15. P

    conditional formatting help

    Hi, I need to have rows highlighted that have to meet 3 criteria in a table and was unsure what statement would be best, two have to be a specific text and one has to be above a certain number.
  16. motherteresa

    Change Color of One Cell IF Another Cell Changes Value in ANY way

    I hope the title is accurate. Looking for a solution through Conditional Formatting for the following: Values in cell L14 AND L15 change. (Both values in L14 & L15 shown to user of WB are a result of a formulas placed in those cells that draw from info somewhere else in the WB). When the...
  17. A

    Delete Mostly Duplicate Row based on Specific Text in 1 Column

    Hi there! My dataset represents work projects and contains columns such as Name, Position, Start Date, and End Date. The columns extend from A to AO, where AO is the end-date. The data is updated weekly, and contains almost entirely exact duplicates. However, where last week's data may have...
  18. M

    Lottery Bingo

    So i have a list of say 10 players down column 'A' To the right of these names there are 6 numbers ranging from 1-59 in separate cells (columns B, C, D, E, F, & G) Somewhere else in the spreadsheet, i want to put the recent lottery results (drawn twice per week) which will consist of 6 numbers...
  19. A

    Highlight Duplicate Rows and Export to New Worksheet

    Hi all, I am working with a large set of data (5000 rows and columns A:AP). I am looking to find rows that are duplicate in their entirety, and then export them to a new sheet. So far I have used a formula to convert each row into a single string (=concat(A5:AP5), and from there I use...
  20. Q

    Making Conditional Formatting ignore hidden rows

    I have a document with multiple filters that cause multiple rows to be hidden. The visible data looks similar to this: <tbody> Column A Row 1 15 Row 3 24 Row 4 13 Row 5 32 Row 11 12 Row 13 20 </tbody> I am trying to create a conditional formatting to highlight the highest 3...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top