A3: =E3>=50% and use paintbrush to apply remainder of column.

E3: Format only cells that contain … ,


Cell value / greater than or equal to / =0.5

Thanks for your reply, however I dont know how to actually implement this in an excel document. Ill needs the A Column to keep the name of the item in there, So in A3 there maybe Widget 1, I need the word widget 1 to stay there but be highlighted if A3 is over the threshold set.