Search : in
By :

Want Original Text Color in Referenced Cell

Matt, on Oct 30, 2009 11:42:33 am GMT 
 Report this message to moderators

Hello,

I have two sheets (A and B). All I want to do is reference fields in Sheet B in Sheet A and maintain the cell's text's color (as in Sheet B). However, in Sheet A the text color of the referenced cell is always black.

How do I keep the text color the same as it is in Sheet B when I reference it in Sheet A?

Configuration: Windows XP Internet Explorer 6.0

Best answers for « Want Original Text Color in Referenced Cell » in :
VB6 Finding the RGB values of a color ShowVB6 Finding the RGB values of a color Dim R as integer Dim G as integer Dim B as integer Sub FindRGB(Col As Long) R = &HFF& And Col G = (&HFF00& And Col ) \ 256 B = (&HFF0000 And Col ) \ 65536 End Sub Note: Here...
[VBA] A function that returns the color of an active MFC Show[VBA] A function that returns the color of an active MFC This function returns the value of the active format in conditional formatting. With the function below, two values can be returned. Mode = 0: the value of Interior.ColorIndex...
Excel tips : How to insert date in a cell ShowExcel tips : How to insert date in a cell Below are some tips on how to insert date and time in an excel cell for a specific purpose:- To insert current date, press CTRL ¯+ ;¯ in the chosen cell. To insert current time, press CTRL¯+...
Download WorldTimer ShowWorldTimer is a custom worldwide clock which can show a certain some number of of clocks in different time zones. It is also possible to change the face of the clock and time zone for each clock, the background color, as well as the text color as...
Spreadsheets - Cell Selection ShowCell Selection Spreadsheets are powerful tools for working with data. However, to work with data, it is necessary to have tools to rapidly choose the required cells. Line Selection An entire line can be chosen by clicking directly on the line...
Spreadsheet - Text Operators ShowConcatenation Operator Spreadsheets generally use an oeprator, called a concatenation operator , that allows two text values to be added together. The concatenation operator, written as &, is used as follows: In the above example, the cell...
Worksheet - Cells ShowThe Concept of a Cell A "cell" is the intersection between a line (horizontal) and a column (vertical) on a worksheet. Thus, the name of the line combined with the name of the column gives the cell's coordinates (the term address is sometimes also...
Ask your question Reply
They need your help