I am trying to do conditional formatting of a few cells. The condition is:
Cell Value = #N/A
and the format is to assign the background color to the font. But for some
reason it doesn't work. The cells doesn't change.
Any ideas what I'm doing wrong here?
Thanks