Need help with IF function

[malsha]

Hi everyone.

I need help using if function.
I've make a set of number in column A,and theres a series of result in column E..
I use a MATCH function to match the number accordingly in column B. Where the result would be #N/A or a row number.
And then i use an IF function to check if column B has number.And if its true=1,false=blank

Is it possible if i want to set the true=1 and also format the cell to a different colour cell and font,so the cell that is true is different for the cells that are blank.

Here is my spreadsheet..

[Fotis1991]

Hi

First in column B, you can use IFERROR function if you don't want to see #NA

=IFERROR(MATCH(A2;E:E;0),"")

2) Highlight C2:C...?

In Confitional Format rules, put this.

=$C2=1.

Choose color>>OK

Is this, works for you?

i