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

G

Guest

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
 
B

Biff

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 Format>Conditional Formatting
Select: Formula IS
Enter this formula in the box: =ISNUMBER(A1)
Click the Format button
Select the style you want
OK out

Biff
 
G

Gord Dibben

Greg

Select the cell.

Format>Conditional Formatting>Condition1>Cell Value is: equal to False

Pick a color from Format>Patterns and OK.

Then hit "Add" button.

Condition2>Cell Value is: equal to True

Pick a color etc. and OK your way out.


Gord Dibben Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top