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