conditional format cells with formula
Your text didn't entirely come through - thanks though!
"Mankind" wrote:
the #N/A. That is what I'm trying to hide this with text color. PLEASE
help?
what kind of hiding u prefer on printing or on the monitor ?
I may not suggest to change your written formula in the cell unless if these
#N/A has no relevance on some other things on your *summary* sheet.<eg
linked?.
"amos" wrote:
I have a summary worksheet that references another with a vlookup table. The
conditional formatting works if a value is entered on the lookup sheet.
However, if the cell isn't filled with a number on the summary sheet I get
the #N/A. That is what I'm trying to hide this with text color. PLEASE help?
|