Excel help please.

[Rangler]

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

 

[Tomsk]

Excel dosen't allow references to other sheets in conditional formatting, so a cell in the current sheet has to be be used as a check.

example
Sheet 1, A1:A10 contains your list of names
Sheet 2, A1:A10 contains list of successes
Sheet 3, A1:A10 contains list of failures

formula in B1 =MATCH(A1,Sheet2!A$1:A$10,0)
repeat formula for B2 to B10
Column B flags successes

formula in C1 =MATCH(A1,Sheet3!A$1:A$10,0)
repeat formula for C2 to C10
Column C flags failures

Conditional formatting for A1

Condition 1
Formula is, =B1>0
set format to green

Condition 2
Formula is, =C1>0
set format to red

Copy and special paste formats into the rest of column A without overwriting existing data.