Right guys,
Having some trouble using conditional formatting.
I have a workbook of about 4000 rows of data.
I am using lookups to pull relevant data onto one sheet to display it in an easier to use manor.
Some of the values are coming up as #N/A, but this was expected.
I am basically trying to use conditional formatting, or something of that kind to replace the "#N/A" error with the word "Solid".
Any help would be greatly appreciated.
Cheers,
Nick
Bookmarks