1. P

    If/Then Conditional Formatting

    I know I am overthinking this. It is not a difficult task. For the life of me, I cannot figure out a simply Conditional Formatting. I have 2 pieces of criteria: If the value in cell D23 is equal to or less than 0 then highlight D9. If the value in cell D23 is greater than 0 then highlight D24...
  2. O

    Highlight cell if value higher

    Hi, I'm trying to compare two columns. When the value in column 2 is higher than in column 1, I highlight the cell. I've selected my first cell (let's say B1) and went to Conditional Formating > Highlight Cell > Greater Than and selected my first cell from my first column (A1). Now, I need to...
  3. B

    Match then highlight and return value.

    Hi There, How can I have the return value highlight in another workbook before being matched and copy into first workbook. =INDEX(Return_value_range, MATCH(Lookup_value, Lookup_value_range, Match_type)) Thanks in advance
  4. R

    Highlight duplicate values when two other pairs of cells have matching values

    Greetings! I'm trying to get find a way to highlight cells so I can see if duplicate values exist during the same day and time. This so I can easily spot these duplicates and change my dates/times in L column to avoid these. In other words: How to highlight duplicate values in cell range...
  5. C

    highlight cells more or less than 0.2 to nearest 1

    Hi, is there any way to highlight the cells in a range, if: the value is more or less than 0.2 to the nearest 1 there are already a formula in each of those cells in the range, which will change according to what i change at the other cell. example: if cell value = 6.09, highlight if cell value...
  6. D

    VBA Highlight Duplicate comma delimited cells in a column

    Hi, Is there a way to highlight duplicates in comma delimited cells that are in a column, I want to compare all comma delimited text values in every cell in a column and highlight the cells that contain the duplicate text, Can someone help with this please
  7. K

    Random Highlight only 1 in the each row

    Using Excel 2000</SPAN></SPAN> Hi,</SPAN></SPAN> I need a VBA, which can highlight 1 character out of 1X2 in the each row so far each time 14 total are selected within the 14</SPAN></SPAN> Example.. <b></b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px...
  8. 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
  9. L

    Finding values that don't have the right # of characters

    I am working with a spreadsheet (received from an external source) where all values should have 9 characters. I want to highlight the cells where the values are fewer than 9 characters. Is there an IF/THEN or some sort of function that I can use to highlight? It is a very large spreadsheet...
  10. 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.
  11. D

    loop column with VBA, tell you how many times it appears

    i want a macro that loops through column F and then tells you if it appears more than twice and highlight those cells.
  12. 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...
  13. 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...
  14. J

    Highlight Row and Column of Selected Cell

    Hello, I need help highlighting the row and column of a cell selected. Any help is appreciated. Thank you.
  15. T

    VBA Color + VLOOKUP

    Hi I am not familiar with VBA and hope that somebody can assist. SheetA: A1 B1 C1 101 98 If I manually highlight cell A1 at C1 = vlookup(A1,SheetB!,2... If I manually highlight cell B1,at C1 = vlookup(B1,SheetC!,2... (Highlight A1, refer sheetB, highlight B1 refer SheetC)...
  16. H

    Highlight all Mondays (or Tuesdays...) that start a week

    Hi. I am using CF to highlight all Mondays in a week using this formula =WEEKDAY(P5)=2 When I populated the dates from left to right across my columns, I filled right with this formula: =WORKDAY(S5,1,Holidays) However, since I've got my Holidays range to ensure that bank holidays aren't...
  17. 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...
  18. L

    Search, find, highlight cell - cells are hyperlinks

    Hi All I'm in need of some help - i'm trying to use conditional formatting to highlight individual cell when a word is typed. So if i start to type the word google - the cell containing the word google highlights red with a yellow font. So if i type g or goo the cell containing the word...
  19. A

    Comparing and finding duplicates on Spreadsheet on two different tabs

    You all rocked my world last time I was faced with a difficult Excel problem, so I'm trying it again! Is there a way to compare/find duplicates on a spreadsheet on different tabs? I have a list of September names on one tab, and have an October list of names on a second tab. Eventually, I'll...
  20. L

    highlight cells then change their values

    Hi I want to select/highlight random cells in a table then multiply them by 20% and then update these cells value. for example A1 = A1 * 20% Then after the update, I want to be able to highlight or select or point to the cells that I just changed their values. Similar idea to the Formula...

Some videos you may like

This Week's Hot Topics

  • Finding issue in If elseif else with For each Loop
    Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
  • MsgBox Error
    Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
    My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
  • Show numbers nearly the same
    Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...
  • Please i need your help to create formula
    I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
  • Got error while adding column and filter
    Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...