You can use Conditional formating

Select the Range E1:E100

Go to Format < Conditional Formatting < Choose < Cell Value is < Equal to <
and Click on G8 it show like this $G8$

Choose Pattern Press Ok



"Excel_Rookie" wrote:

I want to be able to highlight all the cells that have the same text as the
active cell?

So if I'm on G8 and that cell has the word Apples then I want to highlight
all the cells in the E1:E100 range that have Apples in the cell.