I was wondering it were possible to reference an error.
I'd like a cell to have white text if $O19 produces a #N/A error.
I tried formula
=($O19=#N/A)
and the formula
=($O19="#N/A")
but neither work.
Any help would be much appreciated.
Last edited by nesthead98; 11-06-2009 at 03:56 PM.
Hi,
RgdsCode:=ISNA(O19)
Richard Buttrey
If this was useful then please rate it appropriately.
Click the small star iconat the bottom left of my post.
Sweet.
Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks