Changing colour of a number in a cell
Hi, I'm trying conditional formatting to change the colour of a number in cell from black to red if the number is negative. It tried: "If ACTUALS (in the ACTUALS column which the cell is located) ARE LESS THAN $0, then apply BOLD and RED. But it didn't change the colour.
I tried: "Contains $- but nothing changed either.
Do you know of a solution?