Need text in Parenthesis to be a certain color

March 18, 2016 at 12:55:07
Specs: Windows 7
I have a master worksheet: Sheet 1 that is updated monthly. I have a formula that copies over updated info from Sheet 1 only to another worksheet: Sheet 2. I need text on sheet 2 that is in parenthesis to be shown in red to represent updated info. I believe the formula that derbyDad03 offered on Sep. 20, 2010 to blackdevil13 may work, but I am not quite certain how to write the formula and code. Would be glad to email spread sheets with formula so you may see what I am trying to accomplish. I am using this formula =IFERROR(INDEX(Sheet1!$A$2:$C$15,SMALL(IF(Sheet1!$D$2:$D$15="c",ROW(Sheet1!$D$2:$D$15)-ROW(Sheet1!$D$1)),ROW(1:1)),COLUMN()),"") to copy info over to sheet 2

See More: Need text in Parenthesis to be a certain color

Report •


#1
March 18, 2016 at 19:00:08
It might help if you included the link to the thread that you are referring to so that we can see what solution you are talking about.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
March 21, 2016 at 07:49:17

Report •

#3
March 21, 2016 at 09:08:33
As noted in the thread you linked to, as well as this more recent one, you cannot apply rich text formatting to text within a cell if that text was the result of a formula.

http://www.computing.net/answers/of...

Since the "text" isn't really in the cell (the formula is) there is no text for Excel or VBA to format. The standard workaround is to use the formula in one cell and then use VBA to place the value of that formula as text in a different cell. VBA can then format characters within that cell.

If you think that that will work for you, we would need to know how to trigger the VBA to run, either through a manual means (click a button, etc) or via the Worksheet_Change event as done in the code offered at the link you provided.

If you want to post the file to a filesharing site and then post the link back here, we can take a look at it. zippyshare.com is a decent site to use. Please do not use a site that will ask us to register, because odds are that we won't.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

message edited by DerbyDad03


Report •

Related Solutions

#4
March 21, 2016 at 10:51:23

Report •


Ask Question