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="")
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"MJK700i" wrote in message
...
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