highlight

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

Using Excel 2000 Hi, I need VBA, which can do the following task... 1-Column C:D rows highlight in the colour "Light Pink", in the case if finds any same or reversal patterns in the Columns E:F, G:H, I:J, K:L, M:N or O:P same row. 2-Highlight 3 patterns, which can be the same and can be...

Hi all, I am working with a large set of data (5000 rows and columns A:AP). I am looking to find rows that are duplicate in their entirety, and then export them to a new sheet. So far I have used a formula to convert each row into a single string (=concat(A5:AP5), and from there I use...