Excel Conditional Formatting Icon Sets Formula. The conditional formatting dialog has an option for formatting based on a formula which is ideal but the resulting options don t let me use icon sets or data bars etc. Now you need to change the icon.
They only let me change the font formatting borders patterns etc. Apply the conditional formatting icon set rule to. Vlookup invoice product product database 3 false the quantity is then the exact same as the first image unchanged.
Apply the conditional formatting icon set rule to.
Now you need to change the icon. The formula results are shown below for reference. Add an empty column in front of your table column a. Vlookup invoice product product database 3 false the quantity is then the exact same as the first image unchanged.
