Code to condition format the cell colors and font colors of a range values

[mrprofit]

i find that there is alternate mthod using VBA to code the excel condition format, how to use the code to apply to my condition format formula?