SOLVED

Conditional formatting with the help of VBA code

%3CLINGO-SUB%20id%3D%22lingo-sub-3017914%22%20slang%3D%22en-US%22%3EConditional%20formatting%20with%20the%20help%20of%20VBA%20code%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3017914%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20Everyone%2C%3C%2FP%3E%3CP%3EI%20have%20highlight%20those%20%3CSTRONG%3Evalues%20are%20greater%20than%2010%3C%2FSTRONG%3E%20in%20Conditional%20Formatting%20with%20the%20help%20of%20VBA%20code.%3C%2FP%3E%3CP%3EI%20have%20wriiten%20code%2C%20and%20it%20works%20very%20well.%3C%2FP%3E%3CP%3Elike%20-%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%20(5471).png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F330328i6BE45B52DACA93D1%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Screenshot%20(5471).png%22%20alt%3D%22Screenshot%20(5471).png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20when%20i%20change%20value%2C%20then%20it%20is%20not%20clear%20the%20format(less%20than%2010).%3C%2FP%3E%3CP%3EStill%20color%20is%20there.%26nbsp%3B%3C%2FP%3E%3CP%3Elike%20-%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%20(5472).png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F330330iE7127BE5B31B3199%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Screenshot%20(5472).png%22%20alt%3D%22Screenshot%20(5472).png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%2C%20what%20should%20i%20write%20VBA%20code%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20help..%3F%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere%20is%20a%20attached%20file%20with%20code.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3017914%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3017955%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20formatting%20with%20the%20help%20of%20VBA%20code%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3017955%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F811137%22%20target%3D%22_blank%22%3E%40Zan_Hanifee%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESee%20attached%20file.%20Maybe%20this%20is%20what%20you%20want%20to%20do.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Regular 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 Zan_Hanifee (Regular Contributor)
Solution

@Zan_Hanifee 

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