OJ,

Thanks for your help...

I have another question on IF formulae...

I want a cell to display an IF statement if the data in one of 2 cells
displays a certain result.

I've tried the following:
=IF(Data!A1:B1="Overdue","OVERDUE","OK")
to see whether or not the data in Data!A1 or B1 equals 'Overdue' to then
display it as 'Overdue' on the main worksheet, else to display 'Ok'. Is this
possible with just one IF statement?

Kylii


"OJ" wrote:

Kylii,
A worksheet formula cannot effect a change on the formatting (or any
other part, for that matter) of the sheet itself, it can only return a
value to the cell in which it resides. In order to achieve the effect
you are describing you need to look at Conditional Formatting in the
Format menu and in help.

Hth,
O