I have a worksheet that has a project # on the left in Column A.
A B C D
Project #1
Week 1 Rod (B2)
Week 2 Rod

Project #2
Week 1 Rod (B6)
Week 2 Joe

Then I may have up to 15 resource names, Rod, Joe, Fred, Ethyl....
What I would like to do is use code (VBA or macro) to conditionally format the Cells - Fill cell with Red and the text White in each cell when duplicates occur in the same column to tell me that I have already used Rod in Cell B2 and Cell B6 (Example above).

This needs to be done for every column and again I would have up to 15 names.

So I would like to use VBA or a macro to say:
Look in each column for duplicate names, but only in each colum and turn each cell where there is a duplicate name Red with white text to let me know that I already ahve allocated that resource.

Make sense??

I would also like to create a script that would say if you find the word completed in any cell then make the cell green with white text..

I am new to VBA in Excel so i would need some steps through on what to enter and how to enter it in Excel.

Thank You.
Rod