Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Newb needs help....PLEASE!!!
I need some help.....The following is the senario I need to accomplish with a
macro of some sort but am lost on how to do it. I have two worksheets "Sheet1" and "Sheet2" (for simplicity) I want to compare column "I" (it will always be column "I") of both worksheets (column I contains user ID's). If a user Id appears on "Sheet2" and not "Sheet1" I want it to get highlighted. Any ideas on how to get this accomplished would be greatly appreciated. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Newb needs help....PLEASE!!!
Go to Sheet1, highlight your list of names (you can select more cells if you
think additional names will be added in the future), then put your cursor in the Name Box (the empty field to the left of the Formula Bar) and type in a name for the selected cells, say SheetOneList for this example. Next, go to Sheet2, and select all of Column I, then click Format/Conditional Formatting on the menu bar. When the dialog box appears, select "Formula Is" from the drop down and copy/paste this formula in the empty field next to the drop down... =AND(I1<"",ISERROR(MATCH(I1,SheetOneList,0))) Then click the Format button, select the Patterns tab and choose a color you want the cells containing missing names to be tinted in. Finally, OK your way back to the worksheet. Now when you type in names in Column I on Sheet2 that do not appear in the list on Sheet1, those names will be highlighted. -- Rick (MVP - Excel) "SarahJ" wrote in message ... I need some help.....The following is the senario I need to accomplish with a macro of some sort but am lost on how to do it. I have two worksheets "Sheet1" and "Sheet2" (for simplicity) I want to compare column "I" (it will always be column "I") of both worksheets (column I contains user ID's). If a user Id appears on "Sheet2" and not "Sheet1" I want it to get highlighted. Any ideas on how to get this accomplished would be greatly appreciated. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Newb needs help....PLEASE!!!
Thank you very much.....that did exactly what I wanted!!!!!!!!! :) and it
was EASY!!!!!!!!! "Rick Rothstein" wrote: Go to Sheet1, highlight your list of names (you can select more cells if you think additional names will be added in the future), then put your cursor in the Name Box (the empty field to the left of the Formula Bar) and type in a name for the selected cells, say SheetOneList for this example. Next, go to Sheet2, and select all of Column I, then click Format/Conditional Formatting on the menu bar. When the dialog box appears, select "Formula Is" from the drop down and copy/paste this formula in the empty field next to the drop down... =AND(I1<"",ISERROR(MATCH(I1,SheetOneList,0))) Then click the Format button, select the Patterns tab and choose a color you want the cells containing missing names to be tinted in. Finally, OK your way back to the worksheet. Now when you type in names in Column I on Sheet2 that do not appear in the list on Sheet1, those names will be highlighted. -- Rick (MVP - Excel) "SarahJ" wrote in message ... I need some help.....The following is the senario I need to accomplish with a macro of some sort but am lost on how to do it. I have two worksheets "Sheet1" and "Sheet2" (for simplicity) I want to compare column "I" (it will always be column "I") of both worksheets (column I contains user ID's). If a user Id appears on "Sheet2" and not "Sheet1" I want it to get highlighted. Any ideas on how to get this accomplished would be greatly appreciated. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Newb needs help....PLEASE!!!
Sub highlitenonmatch()
On Error Resume Next mySource = Sheets("sheet1").Columns("i") mc = "I" For i = 1 To Cells(Rows.Count, mc).End(xlUp).Row Cells(i, mc).Interior.ColorIndex = 0 If Application.Match(Cells(i, mc), mySource, 0) < 0 Then Cells(i, mc).Interior.ColorIndex = 6 End If Next i End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "SarahJ" wrote in message ... I need some help.....The following is the senario I need to accomplish with a macro of some sort but am lost on how to do it. I have two worksheets "Sheet1" and "Sheet2" (for simplicity) I want to compare column "I" (it will always be column "I") of both worksheets (column I contains user ID's). If a user Id appears on "Sheet2" and not "Sheet1" I want it to get highlighted. Any ideas on how to get this accomplished would be greatly appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Newb VBA sub... | Excel Programming | |||
Newb Q: XLL and XLA? | Excel Programming | |||
Help a newb.... | Excel Discussion (Misc queries) | |||
Can someone please tell this newb what he's doing wrong? | Excel Programming | |||
i know this has to be so easy -newb | Excel Discussion (Misc queries) |