Can you set a range that's conditional on the contents of a cell ?

e.g. where column C contains "Fred" you'd have only the "Fred"s.

And would it include all the other columns in the rows?


Thanks - Kirk