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( A10, [BLUE]B1,[RED]C1)

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


But that IF statement is not correct.


Can you help !

Regards,,,

MJK700i


"JulieD" wrote:

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.

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"MJK700i" wrote in message
...
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.