Excel 2003 Conditional Formatting(Changing text format)?

Up vote 0 down vote favorite share g+ share fb share tw.

Need some help on how to do conditional formatting on excel 2003. I have a cell that will have a text formatting depending on the selected list in excel. E.g.

Selected Dropdown Item-------Cell Value Text------------------------------TEST123.

IF(ISNUMBER(D9),TEXT(D9,"#,##0.00"),TEXT(D9,"")) I'm not sure where you are getting the TEST123 from. If it you are adding to it or just leaving it as plain text. Update: I see what you are asking now.

As far as I know you can't conditional format a number in Excel 2003. I'll do a little searching. You can use VBA though.

It would look like this: set r1=selection if isnumeric(r1. Value2) then r1. NumberFormat="#,##0.00" else r1.

NumberFormat="" end if Update 2: So I guess the question is then, are you added something to the text if it is text? If not just format the number and it will work fine.

Thanks Jon for the quick answer. I would do the VBA Solution as the user will input values on the cell. Thanks – Roy Astro Nov 11 '11 at 0:02.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.