Excel 2003 - assigning colors to cells

O

ohdharleyboy

Hello all-

Excel 2003 Professional - I have a column of numbers (approx 2500 cells in
the column). I wanted the column to look like this:
if the number in the column is <0, then make the cell blue
if the number in the column is >0, then make the cell green
if the number in the column is 0, then do nothing.

Anyone have a good way to tacke this?
Thanks in advance, Jason
 
D

Dave F

Yes, via conditional formatting.

Format--Conditional formatting.

The dialog box is pretty intuitive.

Dave
 
G

Gord Dibben

Format>Conditional Formatting

Condition1 cell value less than 0 format to blue.

Condition2 cell value greater than 0 format to green

0 value needs no condition since that is default.


Gord Dibben MS Excel MVP
 
O

ohdharleyboy

Hello Dave-

Thank you. As a curious follow-up, what if I had a specific character in a
cell (example, an "*"), that I wanted to format on that condition?

Thanks again - Jason
 
Top