When I tried to prove the completeness and cocompleteness of the category of small categories $\mathbf{Cat}$, I thought that proving either one of them could imply the other by taking the dual arguments. But this is not true. Then I have been trying to think about if one of completeness and cocompleteness in $\mathbf{Cat}$ can imply the other.
My question is: In $\mathbf{Cat}$, does one of completeness and cocompleteness imply the other? Under what conditions for a category, one of completeness and cocompleteness can imply the other?
Suppose $C$ is a (locally small) complete category. Then (under enough axiom of choice) it is cocomplete if and only if for all small categories $I$, $\Delta : C\to C^I$ has a left adjoint, that is, if and only if $\Delta$ is a right adjoint.
But the adjoint functor theorem tells us that by completeness, it suffices that $\Delta$ preserve limits and satisfy the solution set condition. Preservation of limits under $\Delta$ is immediate, so the only thing to check is the solution set condition.
So a locally small complete category is cocomplete if and only if for any small category $I$, $\Delta : C\to C^I$ satisfies the solution set condition. You can even restrict to $I$ being either a discrete category, or the category on two parallel arrows. Then you can try to give more concrete interpretations to what the solution set condition means in these cases.
Of course, dualizing all this tells us when a cocomplete category is complete.
A well-known example of all this (where the proof is much simpler though) is that a small complete category is automatically cocomplete (and conversely). In fact, a small complete category is automatically a preorder, in which case cocompleteness follows easily from completeness from order-theoretic considerations.