Conitional Formatting

Hello Alex
Thank you for your question

Highlight the column with the values in it. Then go to the Formatting menu and choose, Conditional formatting. In the first box select 'Cell Value Is', in the second box select 'greater than' and enter 5 in the value box. Click the Format button and format either the font colour on the first tab or the background colour on the pattern tab. Click OK to both boxes and the conditional formatting should take effect immediately.

Ensure the column is highlighted and go back into the conditional formatting tool. Click the add button, You can add another rule for the green/red in the same way.


If this resolves your question, please mark it as resolved. If not, please reply with more information.

Kind regards
Cress