Conditional formatting with icon

Hi Gibtoul,

One quick question, do you need the arrows to be shown in A column itself? Coz using the standard icon formatting, I haven't seen any blue horizontal line or arrow yet and I don't think we can change the color of the icons. So, I have done a workaround to meet your requirements using a formula and fonts. Please see the attached file for the workings. I did the following steps to make it work. Say, I have columns in C and D to be checked for the formatting starting from C3.

1. Created a Dynamic Range - This is the range - "rngFormats" where the formatting will be applied. It depends on the number of filled rows available in column C from C3 onwards. I have used the following function to create the named range.

Please Login or Register  to view this content.

2. Created a Module - This module stores the code for applying the formula and formats to the newly created dynamic range.

Formula : Well, basically you don't have to put the formula manually or drag it, it automatically gets applied to the corresponding range.

Please Login or Register  to view this content.

Macro

Please Login or Register  to view this content.

Just hit on the "Refresh Formatting" to see the work in action. Hope, this helps!

Soyez le bienvenu !
Please mark the thread as [Solved] if your requirement is fulfilled or let us know if you still need some assistance.