Help with hiding rows or conditional formatting

[awirshba]

I'm trying to make a spreadsheet to use for my fantasy football draft. I have one sheet where I will input the draft results live and another with my player rankings. I'd like to have the row (in my player rankings sheet) with a player who has been drafted either disappear or turn red. I have all cells updating live with the draft (using VLOOKUP). I've never used VBA before and when I try to use conditional formatting, it keeps turning the wrong cells red! Any help would be greatly appreciated (draft is tomorrow!!)

For clarification: On the player rankings sheet I have a column that includes the number pick a player was drafted, so I think it might be easiest to do things based on if that value is >0

 

[WinteE]

The conditional format allows you to include a formula. Instead of 'Value is' you'll have to select 'Formula is'.
A formula like VLOOKUP()="Yes" can turn on the format.