Excel Conditional Formatting Icon Sets Formula. If the value is greater than equal to 811. Sign a3 a2 into adjacent cell b3 and then drag the fill handle down to the cells you want to use see screenshot.
Keep selecting the formula cells and then go to the new formatting type dialog. Countblank b2 f2 where f is the last column in your table. Next we apply a standard conditional formatting rule that uses the desired icons.
If the value is less than 811 and greater than equal to 250 percent.
Apply an icon set. Excel vlookup conditional formatting excel 2011. The value that my formula should return is 2 hence the orange dot should be displayed. The formula results are shown below for reference.
