I would like to conditionally format my "#N/A" cells to show red so I can spot values that don't conform to my table...but I can't get the conditional formatting to work.
In the conditional formatting box, I've tried...
#N/A
"#N/A"
'#N/A"
I have it formatted as a text value currently.
Any ideas?
In the conditional formatting box, I've tried...
#N/A
"#N/A"
'#N/A"
I have it formatted as a text value currently.
Any ideas?