highlight

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...

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

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...

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

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...

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.

i want a macro that loops through column F and then tells you if it appears more than twice and highlight those cells.

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...

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...

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

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)...

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...

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...

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...

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...

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...

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...

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...

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?

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...