Copy percentages to another cell .

[I need excel help]

Hello all ,

I am wanting to simply copy two percentages from col E and paste to cols G and H .

When I tried this manually or tried using =E5 or =E6 , the numbers keep changing .
Also tried formatting in all types but no joy .

Needing them to stay in the same colours of green , red or black data .

Red postive numbers
Green negative numbers
Black always zero , 0

A macro is always great but a function can do the same .

Many thanks .