VBA for Conditional Formatting of a text RRS feed

  • Question

  • Hi Experts,

    I have written a code for a large project out of which 90% are recording. However, I am stuck at following situation:

    I have more than 800 texts like below in column A.

    For Example:

    Cell A1- Person1:  +2.9 pts above XY

    Cell A2- Person2:  -2.4 pts below XY

    Cell A3- Person3:  +1.9 pts above XY

    Cell A4- Person4:  +2.0 pts above XY

    Where I need to find statements where values are greater than or equal to +/- 2.0, if match found, then I need to highlight part of statement in red color. (FYI- The number of characters would remain the same after :,If you see above I have highlighted text that comes after colunn (:) )

    I have almost finished this project and stuck at this stage. I would really appreciate if someone can help me with this.




    Wednesday, April 23, 2014 8:37 AM

All replies