if with color 2

[CFNB]

hello.

I have this following peace of code which works fine.
=IF(OR(A13={"UNITED STATES","JAPAN"}),A13,"")

I would like JAPAN to be printed in red and UNITED STATES in bleue.

How would I add this restriction in the code, if it is possible?

Thanks.

 

[SkipVought]

Hi,

You cannot do formatting with a spreadsheet function.

You can, however, do Conditional Formatting, using Format>Conditional Formatting...

You are limited to THREE different formatting conditions. Use one for Japan and one for The United States of America.

Skip,

_[red][/red]

 

[AnotherHiggins]

Formulas can only return an answer. They can't impart any formatting to a cell.

But have a look at Format > Conditional Formatting. You can have two criteria, one for US and another for Japan.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.

 

[CFNB]

perfect!