Fill color when negative
 

How can add a yellow fill when the cell contains a negative value?

Here's a portion of my spreadsheet:

-369.77
30.98
11.48
40.96
-9.04
-54.56
-145.61
-56.56
-243.13
-54.31
-13.27
36.73
-190.88
36.73
37.48
-99.09
-58.04

Fill color when negative
 

On Sunday, January 27, 2013 10:09:00 AM UTC-8, GWC wrote:
How can add a yellow fill when the cell contains a negative value?



Here's a portion of my spreadsheet:



-369.77

30.98

11.48

40.96

-9.04

-54.56

-145.61

-56.56

-243.13

-54.31

-13.27

36.73

-190.88

36.73

37.48

-99.09

-58.04

Conditional Formatting will do that.

Excel 2010:
Home tab Conditional formatting Highlight cell rules Less than Format cells that are LESS THAN: 0 (zero) With 'down arrow' custom format Fill 'select yellow box' OK OK.

Regards,
Howard