I have the following on one worksheet:

A B
School 1 (formatted in green) Nickname 1 (formatted in green)
School 2 (formatted in blue) Nickname 2 (formatted in blue)

On my second worksheet I have a cell that looks up school and returns
corresponding nickname using vlookup. What I need is to have the cell with
vlookup also show the formatting. So if that cell looked up Nickname 1, it
would have green formatting.