Hi Matt,

You're right, I'm using Office 2003 and it doesn't allow number formatting
in the conditional format option. It allows font, border and pattern
formatting only.

I did tried your formula with font color formatting, it did worked. It just
that I need to find a way to get the number formatting done properly.

Thanks for your tips though.

"Matt" wrote:

I was trying to past in the spreadsheet cells for you to look at, but it
won't paste properly into this text editor. It looks something like this. I
have 12.345 entered in every row of column B and column C has the alpha
formatting code.

Column B Column C
12.3 H
1/12/1900 D
12 A

Hope this helps. If you leave the $ out of the formula in front of the row,
it will use whatever row you are currently in from column C in the
conditional formatting statement.