Sure, I can help you with that! You can use
conditional formatting to achieve this. Here are the steps:
- Select the cells that you want to format.
- Go to the Home tab and click on Conditional Formatting.
- Click on New Rule.
- Select "Use a formula to determine which cells to format."
- In the "Format values where this formula is true" field, enter the following formula: (assuming your data is in cell A1).
- Click on the Format button and select the Font tab.
- Choose the color red and click OK.
- Click OK again to close the New Formatting Rule dialog box.
- Repeat steps 3-8, but this time use the formula and choose the color green.
Now, any negative numbers in the selected cells will be displayed in
red, and any positive numbers will be displayed in
green. As the data changes, the formatting will update automatically.