IF fuction and format ...

[Guest]

Greetings

In IF fuction, how can I get answer with different format ... ?

Like if the answer true , I get result with blue font and if the answer
false I get the result in red .

How can I do that ?

Regards

Mustafa J.

 

[JulieD]

Hi

a formula can not change cell formatting. One way, however, to do this is
using Conditional Formatting ... which is on the format menu. Check it out
and if you need more assistance please post back with the IF function you're
using.

 

[Guest]

Hi JulieD, Thank you for replay

I have 3 columns, 1st containing empty and non-empty values, 2nd & 3rd
containing values. The If function checks the 1st set of data if it is
non-empty it gets the results from 2nd set and if it is empty then get the
results from the 3rd set.

The IF function results give a one column of data. I want to know for each
number comes from which set? 2nd set as a blue and 3rd set as a red.

Conditional Formatting give a format depends on the number in a cell not
from other cell.

I am thinking to get a formula like :

=IF( A1>0, [BLUE]B1,[RED]C1)

where [BLUE] and [RED] are results with formatting.


But that IF statement is not correct.


Can you help !

Regards,,,

MJK700i

 

[Max]

Try this ..

Assuming the 3 cols are cols A, B and C,
and the IF formula is in col D, all from row1 down

Select col D

Click Format > Conditional Formatting

Make the settings:

For Condition 1
Formula is: =A1<>""
Click Format button > Font tab > Blue/Bold > OK

For Condition 2
Formula is: =A1=""
Click Format button > Font tab > Red/Bold > OK

Click OK at the main dialog

Col D's returned values will be colored blue/red depending on whether col A
is not empty (the cond: A1<>""),
or is empty (cond: A1="")