Conditional Formatting in Excel

*This feature is in Google Sheets also

First Step

Open your worksheet. Once you have your data in the worksheet highlight the information you want to be formatted. Then click on conditional formatting and select "Highlight Cell Rules".
Big image

Second Step

If you want any positive number to be formatted, first select grater than. Then in the first box type in 0. Next click the drop down bar and choose Light Green fill with Dark Green Text.
Big image

Third Step

Then you can do the same thing with negative numbers, first select Less than. Then in the first box type in 0. Next click the drop down bar and choose Light Red fill with Dark Red Text.
Big image

Final Product

As you can see the numbers that are less than zero should be highlighted with red. The numbers greater than zero are green.
Big image