Mirisage,
You do not need VBA for this. Try this, should do exactly what your looking for...
when you click the conditional formatting button, select this workbook as range, create new rule, select bottom option which is to use a formula, in the formula box that appears try this...
in the box that says "applies to" put this...
hit apply and your done.
Now if your actual spreadsheet is different than the one you posted you just need to change some ranges, in the original COUNTIF formula change the $C$4:$C$10 to whatever your second column with data in it is, the $A4 is the first cell in the first column that has data, and lastly the range for the applies to is your first column that you want data to be compared to against the second column of data.
Hope this helps, Cheers
Ken
Bookmarks