Identify percentages

Hi folks

I'm struggling with trying to identify percentages so that a conditional color can be added to the cell as part of an RAG status listing.

Simply, if cell H11 contains a percentage value eg 3.9% or -3.9% (not 3.9) I would like to add a color (green for the first one, red for the second one)...

The following code works fine with values, but not with cells formatted as percentage.

Please Login or Register  to view this content.

(I cannot use conditional formatting as further down the macro, the cell will be copied and pasted, and using C.F. the formatting remains in place, likewise pasting special. However, if I use a macro to do this, then copy and paste then remove C.F. it works fine)

Have searched the forum, but sufficient to help.

Hope you can help.

Look forward to hearing from you.

NoCanDo

Try with this code:

Please Login or Register  to view this content.

Regards,
Antonio

Hi Antonio (antoka05)

Absolutley excellent - works a charm.

Many thanks for your help, I can now continue with my project.

Kind regards

NoCanDo