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.
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,
Rgds![]()
Please Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Sweet.
Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks