Conditional formatting using two parameters

[Nativus_N00b]

Hi,

I have two columns where I’d like to have both cells turn red when they both have #N/A.

Variations on
AND(L19="#N/A";N19="#N/A")
have not worked.

What am I overlooking?

Thanks

[Villeroy]

Test that formula in a cell before you put it in the c.f. dialog. I guess that the cells in question do not contain the string “#N/A”. They contain the error value #N/A. ISNA(A1) tests A1 for the error value.

[Nativus_N00b]

That was it.

The following now works:
AND(ISNA(L19);(ISNA(N19)))

Thank you!

[PKG]

please refer Untitled.ods (11,5 KB)

[Nativus_N00b]

AND(ISNA($L1);ISNA($N1))

Almost the same (I see I’ve been too liberal with the brackets above)

Many thanks!