- Jul 28, 2006
Hello. I am trying to conditionally format a cell so that when #N/A is returned as a result of a formula, the cell pattern (background) will be yellow. My only options under conditional formatting are 'Value Is' and 'Formula Is' and neither seems to work. What am I missing?