Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Small problem with the conditional formatting of a cell

0

I want to display a green button if the value of each cell in column N ( from N3 to N12 is less than 75%, a yellow button if it is between 75 and 90% and a red if beyond 90%

0n my example the value of N10 is 81% so i expect it to be yellow

what is wrong ???

Answer
Discuss

Answers

0
Selected Answer

Robert

Not sure what's happing here. Cell N10 appears to have only one conditional formatting rule and (as you say) according to that rule the 81% value should give a yellow icon.

I cleared all the conditional formating from N3:N12 and applied a single rule with an icon set with Green >90%, yellow >75% and red otherwise. That seems to give the correct result for N10 (see attached file) but I noted that in your file you had rules per cell and sometimes the icon order was reversed (was that deliberate?)

Hope this helps.

Discuss

Discussion

Thank you so much 
it was my mistake !!! not deliberate
robertpellan (rep: 4) Nov 23, '20 at 8:37 am
Thanks for selecting my answer, Robert
John_Ru (rep: 6092) Nov 24, '20 at 8:10 am
Add to Discussion


Answer the Question

You must create an account to use the forum. Create an Account or Login