Fill color when negative

  • Thread starter Thread starter GWC
  • Start date Start date
G

GWC

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
 
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
Click to expand...

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
 
Back
Top