How can I color the cells in Excel in accordance with the values in the cells, so .e.g -10 is red and + 10 is blue and so on?

Answer 1

Select cells you want to apply conditional formatting to by dragging from start to end.

Then, click Home > Conditional Formatting > New Rule.

In the New Formatting Rule dialog box, click Use a formula to determine which cells to format.

Under Format values where this formula is true, type the formula: =firstcell in selection<0

Click Format.

In the Color box, select Red. In the Font Style box, select any additional formatting desired such as Bold.

Click OK until the dialog boxes are closed.

Repeat the steps except the formula will be =firstcell in selection>=0 and Blue as Font Style.

The formatting is now applied to the desired column(s).