How to highlight a cell if result is a negative number

[livemusic]

If a cell ends up being a negative number, in my spreadsheet, that is not good, as that means it's not a profit, it's a loss. In my summary table using various pricing scenarios, the table is shaded green. Is there a way to change the shading to red for the Profit/Loss column if the results is a negative number? Or how can I make this otherwise stand out?

I mean, some kind of formula... if(a5<1,???)

[Fotis1991]

If you use in Conditional Formating rules this formula?

=$A1<0


*Replace A1 with the cell-range that you want

[livemusic]

Thanks, got it done, I love Excel, cool, lol!

[Fotis1991]

........................