Formatting

Hi Steven,

Thank you for your question.

If you have a column of figures ranging from 100 to 10000, you can format those cells if they meet a particular condition.

E.g. if the cells are greater than 5000, then format those cells in green font with a yellow background. You can then add two addtional conditions such as:

cells greater than 2000 format the font in red and if the cells are less than 2000 then format the font in Blue.

The benefit of this, is as the cell values change, they may meet another condition so the formatting will change accordingly.

I hope this answers your question.

Regards

Simon