HELP : Format cell depending on formula value

  • Thread starter Thread starter Elias Alkalais
  • Start date Start date
E

Elias Alkalais

A range of cells have a formula of this type :
=if(expression_1,expression_2,NA())
If expression_1 = True then A2 = expression_2, cell and font color are set
to the [Automatic] sheet color.
When expression_1 = False and cell value evaluates to #N/A,
how can I force EXCEL to use a different cell and font color ??
I have to use the NA() because then I plot cell range in a XY plot.
I've tried Conditional formatting, but it doesn't seem to work with NA().

TIA
Elias
 
Hi Elias
you can use conditional format:
- select the cell for which you want to apply this format
- goto 'Format - Conditional Format'
- Choose formula and enter: =ISNA(cell_reference)
- Choose your format
 
Back
Top