funtions for colors for fonts or cell backgrounds?

[Yogi Smith]

Is there a way to use a function in a cell to reference another cell and also
make the other cell change colors in background or font. It would be like
using conditional formatting but it would be controlled in a cell. It would
look like this:
=if (A1>0,A1 background is yellow, leave as is)

Are there cell formula change color functions for background and fonts?

Thank you

[Tom Hutchins]

You can use conditional formatting in A1 (in your example) to do what you
described, without involving any other cells.

There are no built-in Excel functions for working with the colors of cells
or fonts. It is possible to write VBA functions to do this. Chip Pearson has
info on his site:
http://www.cpearson.com/excel/colors.htm

But it looks like conditional formatting is all you need, unless there are
additional factors not yet revealed.

Hope this helps,

Hutch

"Yogi Smith" wrote:

> Is there a way to use a function in a cell to reference another cell and also
> make the other cell change colors in background or font. It would be like
> using conditional formatting but it would be controlled in a cell. It would
> look like this:
> =if (A1>0,A1 background is yellow, leave as is)
>
> Are there cell formula change color functions for background and fonts?
>
> Thank you
>

[lostinformulas]

I have a similar type question, I have thousand of lines of information an need to have duplicate infromation highlighted or font color change for easy viewing. I sort the worksheet by the part number column "B"
Example:
Row Column "B"
1 H0000983400008
2 H0000983400009
3 H0000983400010
4 H0000983400010
5 H0000983400010
6 H0000983400011
7 H0000983400012
8 H0000983400013
9 H0000983400014
10 H0000983400015
11 H0000983400016
12 H0000983400017
13 H0000983400018
14 H0000983400019
15 H0000983400020
16 H0000983400021
17 H0000983400022

I would like the cell to highlight or change the color of font on cells 4B & 5B, because this part number has appeared in the row above.

[Tom Hutchins]

You should probably start a new thread, rather than piggybacking on another
one. Nevertheless...

Using the sample data & layout you provided, try the following:

1. Select cells B2:B17 (or whatever the last row of data is)
2. Select Conditional Formatting from the Format menu
3. Change 'Cell Value Is' to 'Formula Is'
4. In the textbox, enter =(B2=B1)
5. Click the Format button and select the formatting options you want to
appear if the condition is TRUE (red bold text, etc.)
6. Click OK

Hope this helps,

Hutch

"lostinformulas" wrote:

>
> I have a similar type question, I have thousand of lines of information
> an need to have duplicate infromation highlighted or font color change
> for easy viewing. I sort the worksheet by the part number column "B"
> Example:
> Row Column "B"
> 1 H0000983400008
> 2 H0000983400009
> 3 H0000983400010
> 4 H0000983400010
> 5 H0000983400010
> 6 H0000983400011
> 7 H0000983400012
> 8 H0000983400013
> 9 H0000983400014
> 10 H0000983400015
> 11 H0000983400016
> 12 H0000983400017
> 13 H0000983400018
> 14 H0000983400019
> 15 H0000983400020
> 16 H0000983400021
> 17 H0000983400022
>
> I would like the cell to highlight or change the color of font on cells
> 4B & 5B, because this part number has appeared in the row above.
>
>
> --
> lostinformulas
> ------------------------------------------------------------------------
> lostinformulas's Profile: http://www.excelforum.com/member.php...o&userid=35229
> View this thread: http://www.excelforum.com/showthread...hreadid=560383
>
>

[Gord Dibben]

See Chip Pearson's site for highlighting duplicates using Conditional
Formatting.

http://www.cpearson.com/excel/duplic...tingDuplicates


Gord Dibben MS Excel MVP

On Tue, 11 Jul 2006 14:47:14 -0400, lostinformulas
<[email protected]> wrote:

>
>I have a similar type question, I have thousand of lines of information
>an need to have duplicate infromation highlighted or font color change
>for easy viewing. I sort the worksheet by the part number column "B"
>Example:
>Row Column "B"
>1 H0000983400008
>2 H0000983400009
>3 H0000983400010
>4 H0000983400010
>5 H0000983400010
>6 H0000983400011
>7 H0000983400012
>8 H0000983400013
>9 H0000983400014
>10 H0000983400015
>11 H0000983400016
>12 H0000983400017
>13 H0000983400018
>14 H0000983400019
>15 H0000983400020
>16 H0000983400021
>17 H0000983400022
>
>I would like the cell to highlight or change the color of font on cells
>4B & 5B, because this part number has appeared in the row above.

[Yogi Smith]

This is very helpful. Thank you very much.

"Tom Hutchins" wrote:

> You can use conditional formatting in A1 (in your example) to do what you
> described, without involving any other cells.
>
> There are no built-in Excel functions for working with the colors of cells
> or fonts. It is possible to write VBA functions to do this. Chip Pearson has
> info on his site:
> http://www.cpearson.com/excel/colors.htm
>
> But it looks like conditional formatting is all you need, unless there are
> additional factors not yet revealed.
>
> Hope this helps,
>
> Hutch
>
> "Yogi Smith" wrote:
>
> > Is there a way to use a function in a cell to reference another cell and also
> > make the other cell change colors in background or font. It would be like
> > using conditional formatting but it would be controlled in a cell. It would
> > look like this:
> > =if (A1>0,A1 background is yellow, leave as is)
> >
> > Are there cell formula change color functions for background and fonts?
> >
> > Thank you
> >