Posted to microsoft.public.excel.programming

external usenet poster

Posts: 26

Copy text cell & change text color conditionally

I want to copy text from cell A1 to cell C1, and if the text in A1 is red,
make C1 black, and vice-versa. There is no formula in A1.

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Button or key to conditionally change text foreground color?	Alex	New Users to Excel	1	February 27th 06 09:40 PM
Button or key to conditionally change text foreground color?	Bob Phillips	New Users to Excel	0	February 27th 06 07:30 PM
Button or key to conditionally change text foreground color?	Bob Phillips	New Users to Excel	0	February 27th 06 07:27 PM
Cell text color change	Steffen	Excel Discussion (Misc queries)	1	February 23rd 05 10:31 PM
Excel VBA - Trying to change color of cell conditionally	abrahamvionas	Excel Programming	5	January 8th 04 09:59 PM

All times are GMT +1. The time now is 04:15 AM.

About Us

"It's about Microsoft Excel"