Search the Community

Hello forrumers I've a little problem and i hope u can help me whit a little problem. There is a excel file whit 2 long rows and 2 tabs. something like this: tab1------------- row1-----row2 M1234--45874 M7896--48656 tab2 row1-------row2 M1234---(empty) M7896---48659 I was hoping to compare these 2 tabs whit 1 script. search (tab 1 row 1 cel 1 ) in (tab 2 row 1) if found fil (tab 1 row 2 cel 1 ) in (tab 2 row 2 cel 1) and make cel green search(tab 1 row 1 cel 2 ) in (tab 2 row 1) if found fil (tab 1 row 2 cel 2 ) in (tab 2 row 2 cel 2) and make cel green iff not found make (tab 2 row 2 cel 2) red until (tab1 row 1 cel ?) is empty What i have this far is : #include <ButtonConstants.au3> #include <EditConstants.au3> #include <GUIConstantsEx.au3> #include <StaticConstants.au3> #include <WindowsConstants.au3> $Form1 = GUICreate("Excel comparer", 649, 219, 192, 114) $Input1 = GUICtrlCreateInput("Input1", 64, 24, 121, 21) $Label1 = GUICtrlCreateLabel("C:\", 16, 24, 19, 17) $Label2 = GUICtrlCreateLabel("Compare row", 16, 96, 66, 17) $Input2 = GUICtrlCreateInput("Input2", 104, 88, 121, 21) $Input3 = GUICtrlCreateInput("Input3", 104, 120, 121, 21) $Label3 = GUICtrlCreateLabel("Fill row", 16, 120, 36, 17) $Button1 = GUICtrlCreateButton("Run", 208, 176, 75, 25, $WS_GROUP) $Button2 = GUICtrlCreateButton("Cancel", 304, 176, 75, 25, $WS_GROUP) $Radio1 = GUICtrlCreateRadio("C:\", 240, 24, 41, 17) $Radio2 = GUICtrlCreateRadio("D:\", 288, 24, 41, 17) $Group1 = GUICtrlCreateGroup("Location", 8, 8, 609, 49) GUICtrlCreateGroup("", -99, -99, 1, 1) $Input4 = GUICtrlCreateInput("Input4", 280, 88, 121, 21) $Label4 = GUICtrlCreateLabel("with", 248, 88, 23, 17) $Label5 = GUICtrlCreateLabel("with", 248, 120, 23, 17) $Input5 = GUICtrlCreateInput("Input5", 280, 120, 121, 21) $Label6 = GUICtrlCreateLabel("from tab", 416, 88, 42, 17) $Label7 = GUICtrlCreateLabel("from tab", 412, 121, 42, 17) $Input6 = GUICtrlCreateInput("Input6", 472, 88, 121, 21) $Input7 = GUICtrlCreateInput("Input7", 472, 120, 121, 21) $Group2 = GUICtrlCreateGroup("Group2", 8, 72, 609, 81) GUICtrlCreateGroup("", -99, -99, 1, 1) GUISetState(@SW_SHOW) While 1 $nMsg = GUIGetMsg() Switch $nMsg Case $GUI_EVENT_CLOSE Exit EndSwitch WEnd as you can see i prety new in autoit vs excel. I hope there is somebody that can help me whit this Greez FMS