TWO ACCOUNT MATCH

[Yaseen Al-Lawati]

dear members,
on daily basis I check our securities against the accounts
manually.(SECURITY ID AND NOMINAL VALUE)
is there anyway that I can let excel do the work
what I mean is puting our securities in a column and the accounts securities
in another column, and if the accounts security is avaliable in our list and
the amount match it turns to green or any indication that both columns match
(SECURITY AND NOMINAL VALUE)
thank you very much

 

[GoBow777]

securities in a column and the accounts securities
in another column, and if the accounts security is avaliable in our
list and
the amount match it turns to green

Conditional formatting is what you want.

http://www.contextures.com/xlCondFormat03.html