![up and down arrows in excel conditional formatting up and down arrows in excel conditional formatting](https://i.stack.imgur.com/Dg63d.jpg)
Click OK in each of the three dialog boxes that are open. Click the Format button and the Fill tab, then choose a light-red color.In Format Values Where This Formula Is True, type =C12
![up and down arrows in excel conditional formatting up and down arrows in excel conditional formatting](https://4.bp.blogspot.com/-Xc81kaiwHtY/VuWmQzNKZHI/AAAAAAAAEEU/oRK7tpMUjbc_RUABDkg6nTfmlHkZEjlEQ/s1600/Change%2BChart.png)
Open the Paste dropdown and choose Linked Picture.
![up and down arrows in excel conditional formatting up and down arrows in excel conditional formatting](https://cdn.wallstreetmojo.com/wp-content/uploads/2019/09/Icon-Sets-in-Excel.png)
In cell G2, enter the formula =SIGN(C2-B2).Follow these steps to set up the icon set: In Figure 2, the helper cells are shown in columns G through I, but you could also put them in columns AX through AZ or somewhere else outside of anyone’s view. You will use some helper cells to make this work. It’s essentially a green up indicator, a yellow flat indicator, and a red down indicator. Microsoft added icon sets in Excel 2007, but the set they call Three Triangles debuted in Excel 2010.