Want to change the color of a true/false logical statement with i.
 

Trying to change the color of the results generated from a if:then,
true/false logical statement with in a formula. I would be happy if I could
change the format of the cell using a information formula
(=isnumber():color,34) or something like this. The goals is not to use the
format menu from the tools bar, but to automat this action. I am trying to
avoid using a macro, which again would require an action on the tool bar.
Thank you for any tips, GREG

Hi!

Don't understand your desire to not use the format menu or
a macro. Well, without one of those methods you won't be
able to accomplish what it is you want to do.

You can't use a formula to color a cell. Here's your best
option:

Select the cell in question, assume it's A1.
Goto FormatConditional Formatting
Select: Formula IS
Enter this formula in the box: =ISNUMBER(A1)
Click the Format button
Select the style you want
OK out

Biff

-----Original Message-----
Trying to change the color of the results generated from
a if:then,
true/false logical statement with in a formula. I would
be happy if I could
change the format of the cell using a information formula
(=isnumber():color,34) or something like this. The goals
is not to use the
format menu from the tools bar, but to automat this
action. I am trying to
avoid using a macro, which again would require an action
on the tool bar.
Thank you for any tips, GREG
.

Greg

Select the cell.

FormatConditional FormattingCondition1Cell Value is: equal to False

Pick a color from FormatPatterns and OK.

Then hit "Add" button.

Condition2Cell Value is: equal to True

Pick a color etc. and OK your way out.


Gord Dibben Excel MVP

On Fri, 18 Feb 2005 19:27:03 -0800, "gregspainting"
wrote:

Trying to change the color of the results generated from a if:then,
true/false logical statement with in a formula. I would be happy if I could
change the format of the cell using a information formula
(=isnumber():color,34) or something like this. The goals is not to use the
format menu from the tools bar, but to automat this action. I am trying to
avoid using a macro, which again would require an action on the tool bar.
Thank you for any tips, GREG