Evening all,
Im after bsome excel help if possible.
Picture this, i have a workbook with 3 sheets as follows.
Sheet 1 (PC Names) = List of computer names
Sheet 2 (Success) = List of computernames
Sheet 3 (Failures) = List of computer names
What i want to do is on sheet 1 check if computername exists in sheet 2 and if so colour it green and if it exists in sheet 3 colour it red.
I've had a look at conditional formatting but i dont hink it will do what i want.
Basically i've a script which is processing a list of 3000 pc's and resetting the local admin password then presenting me with a 2 text files one for success and one for failures which im them copying into excel.
Hope this makes sense?
Any thoughts.?
Im after bsome excel help if possible.
Picture this, i have a workbook with 3 sheets as follows.
Sheet 1 (PC Names) = List of computer names
Sheet 2 (Success) = List of computernames
Sheet 3 (Failures) = List of computer names
What i want to do is on sheet 1 check if computername exists in sheet 2 and if so colour it green and if it exists in sheet 3 colour it red.
I've had a look at conditional formatting but i dont hink it will do what i want.
Basically i've a script which is processing a list of 3000 pc's and resetting the local admin password then presenting me with a 2 text files one for success and one for failures which im them copying into excel.
Hope this makes sense?
Any thoughts.?