Excel Conditional Formatting Icon Sets Formula. Home conditional formatting icon sets. Click conditional formatting icon sets under home tab then select the icon set you prefer.
Copy the following formula across column a. Here is the conditioning with the formula being. Apply an icon set.
If the value is greater than equal to 811.
Compare adjacent rows cells with conditional formatting icon set in excel. Use icon sets to highlight values in conditional formatting in excel. The value that my formula should return is 2 hence the orange dot should be displayed. The formula results are shown below for reference.
