How can I return a color instead of a value using the function "if
 

How can I return a color (fill an specific cell with a color) using the
conditional formula "IF" instead of returning an specific value or both, a
value and a color.

In example, If AB
If false fill the cell in RED and return the value 0
If true fill the cell in GREEN and return the value 1

How can I return a color instead of a value using the function "if
 

Antonio,

Not sure what you want to do, but it sounds like you can use a normal if
statement (=if(xxx,1,0) and use conditional formatting to colour the cell
based on the value in the cell (format - Conditional formatting).

Press the Add button in the Conditional formatting box to add more review
lines, but easier is to have a standard color in normal formatting (ie green)
and only make it red using conditional formatting when the value is equal to
0.

How can I return a color instead of a value using the function "if
 

Use conditional formatting. See
http://www.contextures.com/xlCondFormat01.html

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Antonio" wrote in message
...
How can I return a color (fill an specific cell with a color) using the
conditional formula "IF" instead of returning an specific value or both, a
value and a color.

In example, If AB
If false fill the cell in RED and return the value 0
If true fill the cell in GREEN and return the value 1