Change color without conditional formating

[Guest]

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".

 

[David Biddulph]

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

 

[Guest]

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

 

[David Biddulph]

Why are you so keen on avoiding CF?

 

[Gord Dibben]

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

 

[Jim Cone]

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" <[email protected]>
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".