Quote:
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