SOLVED

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)
Solution

@Excel 

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