• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Show Custom Icons according to Values

D

dramnath1981

Member
Guys,

I need your expert help to show the relevant custom icons in Column C according to the values in Column B.

I have attached the file for moe clarity. Your kind help is much appreciated.

Regards, Ramnath
 

Attachments

  • Sample Icon File.xlsx
    10.7 KB · Views: 1
You are really a Ninja. You deserve the title.

It took me 5 minutes to understand what you did. Today I have learned somthing really awesome. This is a new dimension of how to use Conditional Fomatting and Wingdings Font together.

May be Chandoo can publish an article on Conditional Formatting using this technique.

Thanks & Regards, Ramnath
 
One more clarification please....

When I check the Conditional Formatting by keeping the cursor for example in Cell C11 or C16, the Formula there still refers to $D10 only. But there is nothing wrong with the result.

Any reason why it shows only the first value in the Range even when the selection changes? Just for my knowledge.
 
In order to apply formatting to all cells below D10 i have not placed the dollar sign before 10. Please try $D$10 and see results.
 
You must log in or register to reply here.
Back
Top