formatting

  1. Z

    Conditional Formatting Based on Headers

    I am having trouble coming up with code that will scan the column headers, strings, and then apply the specific conditional formatting based on values in that column. The order of the columns can vary depending on how individuals pull the report. I want the formatting consistent despite the...
  2. L

    conditional formatting - like reverse lookup

    Hi I want to highlight "pass" in result column to different color but not only pass but student name that correspond to that pass For example, cell F2 = pass should be highlighted to different color and also Mary1 as well (like reverse lookup) I can use conditional formatting to highlight pass...
  3. L

    copying conditional formatting to different sheet

    Hi I have no problem to copy conditional formatting from one cells to another in the same sheet using format painter tool. But I noticed I can not copy conditional formatting to different sheet? Is that by design? Thank you
  4. P

    TITLE Link Formatting of Another Cell

    Hello All, I am trying to retrieve the formatting of the cell that is Matched using the INDEX and MATCH functions and then apply that formatting exactly to a cell currently using this formula: =IF(D1="","",IF(INDEX('WORK ORDER DATABASE'!W7:W157,MATCH(CO19230COLP!D1,'WORK ORDER...
  5. P

    Conditional Formatting

    Can you do conditional formatting on a column based on last number in each cell. I need to highlight all cells that end with a 6 in a particular column. Thanks
  6. T

    Copy paste values only

    Hi there, In a peice of VBA code I am a using Copy-Paste with xlValues as follows: Dim Sourcebook, Targetbook as Workbook Dim Sourcesheet, Targetsheet as Worksheet Dim Sourcerange, Targetrange as Range ........ Sourcebook.Sourcesheet.SourceRange.Copy...
  7. J

    How to change text to red if value in cell changes and add last updated on date to the row

    I need to change the cell text format to RED if the value of the cell is changed (not formatting or just clicking in it). Additionall, when the cell is changed in a row, a column at the end needs to show the date last changed (mm/dd/yyyy) and name of computer that changedit. Is this...
  8. T

    IF/OR Usage to format cells based on given value in any set of columns

    Hi, I want to format the A column depending on the data in I J and K column so i could make 3 different Formatting rules =$I1="True" But what if i want to do I J and K in the same formatting rule? Sorry if its a bit unclear
  9. M

    Conditional Formatting - need to add a "not equal to" to my formula

    Maybe it's because it's soo late and I'm here working on this but I can't figure this out. Help from the masters would be appreciated. I have a conditional formatting formula already setup and it works... <date(2019,8,2))) AND(($AZ10>0.249),($F10<date(2019,8,2))) <DATE(2019,8,2)))...
  10. M

    Import CSV (UTF-8) to Excel without formatting

    I have code for pasting data from CSV file to Worksheet. Everyhting works fine but I am facing some problems with current solution. Is there a way to paste data as it is without formatting? Now Excel is formatting for example -Name to =-Name so there #Name ? errors instead of Values. Also it...
  11. G

    Conditional formatting question

    Hello, I have applied conditional formatting to a range ofcells, for example A1 to D1 and the cells are colour coded based on the value. I am now struggling as the cells in A2 to D2 need to be formattedin the same colour, is there a way to Link the colour format ? SO effectively A1 and A2 would...
  12. H

    Questions on conditional formatting

    Hi, Possible to use conditional formatting to 'sum count' font colour? 1 2 The ans should be 2 'count'
  13. J

    Conditional formatting highlight

    Hi, My formula seem to be wrong. Can any one please help me check the formula. Appreciate in advance. Thank you. https://drive.google.com/drive/folders/1GONwJfx01v_XZeHrg3burkBavuF3ffIJ?usp=sharing
  14. I

    Conditional formatting by merged cells

    Hello, I have set conditional formatting in specific range. If is not empty then background color = green + outer borders. I sometimes use merged cells in this range and by merged cells is the borders unfortunately not complet. Is there any way how to solve it? thank you very much Miroslav
  15. J

    Conditional Formatting - Highlighting differing values

    Hi all, If I have multiple columns that I'm identifing differences in, and what to highlight those differences. What conditional formatting formula could I use? Example: Columns A2 and B2 should be the same, but they are different values. I want to highlight both cells. This rule would be...
  16. L

    Conditional Formatting

    Hi I have the following data on a sheet. It is basically a calendar that shows a persons days off. Role 0 are fixed days off people. Role 1 is to be ignored. I want a conditional formatting to be true when the following are satisfied: 1. Column B = 0 2. If the day (Row 1) for the...
  17. K

    Adding a vertical line in conditional formatting data bars at 100%

    Hello, I have a budgeting sheet where I'd like to show a vertical line against some progress bars at a value other than zero. In particular, I'd like to highlight where budgets are at more than 100%. It looks like conditional formatting can only handle that if the value you're targeting is zero...
  18. N

    Index and Match formula

    Hello, I have 2 problems that I am trying to solved. I did my best to search forums but I just cannot seem to find answers (Probably I am not able to interpret the issue properly, been learning excel for more than a month now) 1. trying to use...
  19. A

    Conditional Formatting?

    Hi everyone! I need to make certain cells on a report highlighted based on 2 conditions from raw data. Basically what I need is: If the date in range V2-V400 is today, AND the number in range Y2-Y400 is the same as say A2, then I need A2 to be highlighted. I've been told by a colleague that...
  20. B

    CSV - Data format doesn't save

    Hi, I have a CSV and have formatted the date as DD/MM/YYYY but when I save the file and come to reopen, the formatting has gone, any idea why please?

Some videos you may like

This Week's Hot Topics

Top