Conditional formatting with the help of VBA code

Super Contributor

Hello Everyone,

I have highlight those values are greater than 10 in Conditional Formatting with the help of VBA code.

I have wriiten code, and it works very well.

like - 

Screenshot (5471).png


But when i change value, then it is not clear the format(less than 10).

Still color is there. 

like - 

Screenshot (5472).png


So, what should i write VBA code?


Please help..??



Here is a attached file with code.


1 Reply
best response confirmed by Excel (Super Contributor)


See attached file. Maybe this is what you want to do.