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

Yes, via conditional formatting.

Format--Conditional formatting.

The dialog box is pretty intuitive.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"ohdharleyboy" wrote:

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

FormatConditional 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

On Fri, 2 Feb 2007 13:11:00 -0800, ohdharleyboy
wrote:

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

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

"Dave F" wrote:

Yes, via conditional formatting.

Format--Conditional formatting.

The dialog box is pretty intuitive.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"ohdharleyboy" wrote:

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