column text

crt · May 24th, 2002, 04:30 PM

Hello again,
I'm new at this so i have questions.
I want the text in a column to change color based on the value i.e.
black >0 red <0.
Do I do this in a macro or is there an easier way?

IML · May 24th, 2002, 04:37 PM

You can simply highlight your numbers, right click, and choose format cells. Select "number" and simply pick a format of the negative numbers of your liking. Hit Okay and you're done.

crt · May 24th, 2002, 04:52 PM

Thank You.
I had to go into custom to get what I wanted but it worked

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 24th, 2002, 04:30 PM	#1
crt New Member Join Date: May 2002 Posts: 11	Hello again, I'm new at this so i have questions. I want the text in a column to change color based on the value i.e. black >0 red <0. Do I do this in a macro or is there an easier way?

May 24th, 2002, 04:37 PM	#2
IML MrExcel MVP Join Date: Feb 2002 Location: Denver, CO Posts: 1,744	You can simply highlight your numbers, right click, and choose format cells. Select "number" and simply pick a format of the negative numbers of your liking. Hit Okay and you're done.

May 24th, 2002, 04:52 PM	#3
crt New Member Join Date: May 2002 Posts: 11	Thank You. I had to go into custom to get what I wanted but it worked