Conditional Formatting (Excel 2000)

Topic

New Reply

Is it possible to conditionally format a cell based on if the formula returns an error message? For example can you set the font color to be red if the formula returns #N/A

Reply | Quote

Replies

Set the Condition to :

Formula Is =ISNA(A1)

where A1 is the cell to be formatted and hold the result (N/A)

A.C.

Reply | Quote

I have tried several version of an IS formula including the one you suggested. They work if I place them in another cell then reference the cell in my Formula Is but not if I place them directly in the Conditional Formatting for the cell.
Thanks

Reply | Quote

It seems to work for me – see attached

Andrew C

Reply | Quote

I gave it one more try and it worked this time (??). Thanks for persevering.

Reply | Quote