Conditional Formatting, Formula is: =ISNA(A1)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.


David said:
Greetings and TIA for your help,
I have a preformatted range (mixed number, border, fill, etc formats) that
Click to expand...
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?
 
Back
Top