conditional

  1. W

    Sum conditional formatted cells

    Hi all, I am trying to sum all of the green cells (see picture @ https://ibb.co/vjVRrBC). Green cells are formatted using a conditional formatting formula rule. The purpose of the formating is to highlight every cells in columns U that I have room for in my budget (C8) starting from the top...
  2. L

    Conditional Format formula

    I would appreciate any help with the following. A1 contains the name of a city say Reading. F1 contains a mnemonic for that city which in this case is logically RE. However the RE is not always the only letters in the cell. So what I need is a CF formula that will check if the first 2...
  3. T

    conditional formatting

    Hello, if the delta between cells H2 and J2 is >=2% color cells red. thanks in advance
  4. T

    Conditional Formatting

    Is it possible to use conditional formatting to highlight a cell if it is the active cell and how would you do that? Thank you
  5. A

    highlight row and column

    I need to highlight range in excel. for eg. if i select "F6" in excel then column F and row 6 highlighted with color. is this possible with conditional formatting ?? or there is any other option to do this.
  6. D

    Conditional Formatting with two values

    <tbody> 123456 Murdock 123555 Murdock 123456 Murdock </tbody> I'm trying to get the first and the third rows to get filled in a Color since both the ID and the Name are the same value. The second row should not be filled. Any ideas?
  7. L

    conditional formatting - bar based on value

    Hi I created a conditional formatting based on the value of the cell excel would insert bar as below. The bar can move from left to right or right to left. My question can I create similar bar but move from bottom to top? is that possible? Thank you very much
  8. K

    Conditional formatting each next step

    Using Excel 2000</SPAN></SPAN> Hi,</SPAN></SPAN> Here the below is my example I need Formula is preferable or an alternative VBA for conditional formatting to highlight each next step pattern in the complete row as per "specific pattern shown in the cells C4, D4 & E4 which is changeable as...
  9. J

    Conditional Format based on Multiple Text Possibilities in another cell

    I currently have the following Conditional Format rule that changes fill color of cells in column A based on Text found in column B. Formula chosen is =AND($A1="", $B1="EE") Applied to =$A$1 I would like to add additional Text items to look for so that It will change the color if "EE" or "H"...
  10. K

    Formula for conditional formatting

    Using Excel 2000</SPAN></SPAN> Hi,</SPAN></SPAN> Here the below is my example I need formula for conditional format to highlight result in 3 different forms highlight 2 match, 3 match or 4, for example if I put in the cell C3=1 & in the D3=2 it should highlight in the column C6:D44 all 2...
  11. S

    Conditional Formatting Formula

    I need to write a formula that highlights cells that contain an error if the next cell contains the word "Venmo." IF (AND (I3=ISERROR , J3 CONTAINS THE WORD VENMO)) then color the cell red I know my formula is silly, but think it conveys what I am trying to do?? :-D TIA!!! Sarah PS, I know...
  12. 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...
  13. C

    Conditional formatting

    In conditional formatting I would like to highlight the whole row when yes is entered into cell M2 then each row after that. Sorry cannot paste table into here Thank you for any assistance <colgroup><col><col><col><col><col><col><col><col><col><col><col><col span="2"></colgroup><tbody>...
  14. G

    Conditional Format with Search and Days

    Hello, I'm attempting to add conditional formatting to a sheet. The Conditional Format is based on: 1) Column A contains the word "Sales" AND Column C is < 30 2) Column A does not contain the word "Sales" AND Column C is < 90 I attempted to build out the formula, but it does not work as...
  15. 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...
  16. V

    Change color conditional formatting - quick way

    Hi, I have several columns. Each column needs to highlight certain times in a certain color. For each column the time and color is different. Column A 9:00 (color Blue) Column B 5:00 (color Green) Column B 6:00 (color Yellow) Column C 8:00 (color Red) Column C 9:00 (color Light Blue) etc...
  17. 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...
  18. L

    conditional formatting

    Hi I have the table below. I want to use conditional formatting or any other way to highlight the event based on condition like the following: If the event takes less than 14 days, then I highlight "Current" in the 3rd column. but not to highlight the "xmas" or any other events which have...
  19. 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
  20. avisoft20

    Conditional Format

    Dear All Expert, I am working on a data i need conditional format formula. Example: <tbody> Date Material Code 01/10/2019 2002025 01/10/2019 2002025 01/10/2019 2002115 </tbody> Condition:if material code is same on same date it will be highlighted. Thanx & Regards. Avisoft

Some videos you may like

This Week's Hot Topics

  • Importing multiple excel files into one spreadsheet
    Hi, I'm trying to import multiple excel files (with the same format into a single spreadsheet) so that each day's file is listed underneath the...
  • find many based on a certain criteria
    good evening, I hope someone can help me? I have a workbook sheet 2 contains lots of data.... I would like to be able to find anything on sheet...
  • How to copy multiple rows using If
    Hi all, I'm very new to VBA and have written this simple code to copy certain cells if a certain cell within that row contains any data. I need...
  • VBA If statement
    Dear All, I have two dates, where I'd like a message box to pop, if the dates are between this criteria. [CODE] sDate1 = #10/1/2019#...
  • Text Format
    I have a sheet for user to keyin the data. The format of the data can be 451 / 1903, 0012 / 9908 or 00287 / 0099. The number after the "/" is...
  • Syntax errors
    Good Morning, Trying to compile a workbook, I keep getting a few errors. Here are the first two: [code=rich]Syntax Error: Function...
Top