1. 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...
  2. 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
  3. 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...
  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. 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...
  6. 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.
  7. 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.
  8. 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...
  9. 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...
  10. 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.
  11. 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)...
  12. 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...
  13. 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...
  14. 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...
  15. 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...
  16. 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...
  17. B

    Conditional Format Brain Fart

    Hello all, I am struggling with what I think should be pretty simple. I checked around for examples and still stumble. Please help. Column C has a number Column W has a number I need the cell in column W to highlight if it does not equal column C Both of these columns should be equal...
  18. M

    Conditional Formatting (I think

    Hi All I need a really simple way to highlight a cell based on the contents of another - but am getting confused. In short - I need cell B9 to highlight red when: B9 is empty and N9 has data. Also, I would like cell B9 to highlight orange when: B9 has data and N9 is empty Both B9 and N9...
  19. sharky12345

    Highlight cells less than 100% but ignore blanks

    I'm trying to use the conditional formatting option to highlight cells where the value is less than 100%, (the cell values are percentages), but I need to ignore any cells that are blank. Can anyone help me please?
  20. J

    Highlight Dollar Amounts

    I have a list of work order comments in range H2:H1150. In each cell is a comment like this: "1/8/10 Employee at work-----refer to doctor----$750 cap per listing." I am trying to extract just the dollar amounts from these cells so I can total them in column I but am having a hard time. I...

Some videos you may like

This Week's Hot Topics