I know that I can use conditional formatting to change the color of a cell,
but this can prove cumbersome for multiple cells and multiple values.

Is there a way to change the color of a cell based on a formula in that cell?

For example, assume I have cell A1 = 10 and plan on entering a list of data.
I want to compare each value to cell A1 and change the color accordingly.

I would assume the code would then be as follows:
=if(a2<a1,color=red,color=green)

However, there appears to be no command such as "color" or "fill".

Format/ Conditional Format/ Formula is:
=A2<$A$1 and choose your red format.
--
David Biddulph

"spacesyco" wrote in message
...
I know that I can use conditional formatting to change the color of a cell,
but this can prove cumbersome for multiple cells and multiple values.

Is there a way to change the color of a cell based on a formula in that
cell?

For example, assume I have cell A1 = 10 and plan on entering a list of
data.
I want to compare each value to cell A1 and change the color accordingly.

I would assume the code would then be as follows:
=if(a2<a1,color=red,color=green)

However, there appears to be no command such as "color" or "fill".

Is there a way to do it without using conditional formatting?

"David Biddulph" wrote:

Format/ Conditional Format/ Formula is:
=A2<$A$1 and choose your red format.
--
David Biddulph

"spacesyco" wrote in message
...
I know that I can use conditional formatting to change the color of a cell,
but this can prove cumbersome for multiple cells and multiple values.

Is there a way to change the color of a cell based on a formula in that
cell?

For example, assume I have cell A1 = 10 and plan on entering a list of
data.
I want to compare each value to cell A1 and change the color accordingly.

I would assume the code would then be as follows:
=if(a2<a1,color=red,color=green)

However, there appears to be no command such as "color" or "fill".

Why are you so keen on avoiding CF?
--
David Biddulph

"spacesyco" wrote in message
...
Is there a way to do it without using conditional formatting?

"David Biddulph" wrote:

Format/ Conditional Format/ Formula is:
=A2<$A$1 and choose your red format.

"spacesyco" wrote in message
...
I know that I can use conditional formatting to change the color of a
cell,
but this can prove cumbersome for multiple cells and multiple values.

Is there a way to change the color of a cell based on a formula in that
cell?

For example, assume I have cell A1 = 10 and plan on entering a list of
data.
I want to compare each value to cell A1 and change the color
accordingly.

I would assume the code would then be as follows:
=if(a2<a1,color=red,color=green)

However, there appears to be no command such as "color" or "fill".

Formulas return values.

Some formatting can be done with a formula like

="Payment due " &TEXT(H15,"mmmm, d yyyy") & " " & TEXT(I15,"$#,##0.00")

But cannot change colors.

That's what CF is used for.

You always have the recourse of VBA code.


Gord Dibben MS Excel MVP


On Tue, 20 Mar 2007 14:00:36 -0700, spacesyco
wrote:

Is there a way to do it without using conditional formatting?

"David Biddulph" wrote:

Format/ Conditional Format/ Formula is:
=A2<$A$1 and choose your red format.
--
David Biddulph

"spacesyco" wrote in message
...
I know that I can use conditional formatting to change the color of a cell,
but this can prove cumbersome for multiple cells and multiple values.

Is there a way to change the color of a cell based on a formula in that
cell?

For example, assume I have cell A1 = 10 and plan on entering a list of
data.
I want to compare each value to cell A1 and change the color accordingly.

I would assume the code would then be as follows:
=if(a2<a1,color=red,color=green)

However, there appears to be no command such as "color" or "fill".

You can change the font color as the cell value changes using a
custom number format. For instance...
[Blue][10]General;[Red][<=10]General; General
(more than ten the font is blue; ten and under the font is red)
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"spacesyco"
wrote in message
I know that I can use conditional formatting to change the color of a cell,
but this can prove cumbersome for multiple cells and multiple values.

Is there a way to change the color of a cell based on a formula in that cell?

For example, assume I have cell A1 = 10 and plan on entering a list of data.
I want to compare each value to cell A1 and change the color accordingly.

I would assume the code would then be as follows:
=if(a2<a1,color=red,color=green)

However, there appears to be no command such as "color" or "fill".