![Ms outlook conditional formatting keeps resetting](https://kumkoniak.com/113.png)
![ms outlook conditional formatting keeps resetting ms outlook conditional formatting keeps resetting](https://cdn.extendoffice.com/images/stories/doc-outlook/copy-automatic-conditional-formatting/doc-copy-automatic-conditional-formatting-1.png)
Therefore, click on “Highlight cell rules” and “Less than”.Ĭhose “0” in the field “Format cells that are less than” and decide for a formatting option. For our example, we want to mark cells with a value less than zero with a red background color. This function allows you to change colors of cells based on their value: You can choose between “Less than…”, “Greater than…”, “Between…” and many more options. Mark the cells you want to highlight with colors according to their value.Ĭlick on the tab named “Home” and find the button “Conditional formatting”. To immediately spot negative values, you can highlight these cells using the if-function.Īs a starting point, prepare a list of all your accounting transactions. So, let’s imagine you’re recording accounting transactions. The easiest way to explain how changing the colour of Excel cells via the if-function works is by using an example.
![Ms outlook conditional formatting keeps resetting](https://kumkoniak.com/113.png)