Conditional Formatting, Formula is: =ISNA(A1)

[David]

Greetings and TIA for your help
I have a preformatted range (mixed number, border, fill, etc formats) that I would like to apply conditional formatting to when the cell value = #N/A. I have succesfully applied it to a single cell and am looking for a way to copy the conditional formatting over to the rest of the range without changing the existing mix of number formats etc. ... Alternatively, maybe I can apply the formula to the whole range at once as an array formula?

 

[Andy B]

Hi

If you select your range first and base your formula on the first cell
selected it will copy this formula to the rest of the range automatically.

--
Andy.

Greetings and TIA for your help,
I have a preformatted range (mixed number, border, fill, etc formats) that

I would like to apply conditional formatting to when the cell value = #N/A.
I have succesfully applied it to a single cell and am looking for a way to
copy the conditional formatting over to the rest of the range without
changing the existing mix of number formats etc. ... Alternatively, maybe I
can apply the formula to the whole range at once as an array formula?