LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 26
Default Cond. format text color based on another's text color

I want to copy text from A1 to C1, and if A1 text is red, then the copy
should be black(automatic), and vice versa. Can I do this in conditional
formatting, or do I need to go to VBA?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Text Color Change prompted by different columns NKDodd Excel Worksheet Functions 1 August 15th 06 08:13 PM
Conversion to Text file format error Rob Excel Discussion (Misc queries) 1 June 26th 06 10:33 AM
How do I use cond format formula to set cell text and color? sbwilliams Excel Discussion (Misc queries) 4 January 8th 06 10:20 AM
Changing cell format - for example text to numeric sjrku Excel Discussion (Misc queries) 3 December 30th 05 10:40 PM
How do i change numbers in text format to number format? Greg New Users to Excel 1 December 14th 04 05:22 PM


All times are GMT +1. The time now is 05:06 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"