Hi,
On Sheet2 of the attached I've put in a very simple vlookup formula that returns one text value and one numeric value. Then applied your conditional formatting using ISTEXT. Seems to work fine and the formatting is applied to the text value and not to the numeric one.
Did you get a different result when you tried it?
If I've been of help, please hit the star
Hi Spencer, in col A, I have as you've seen, an array formula that is copied down to row 29. I also have CF in A4 set as ISTEXT(A4)´, then draw a border. If I format paint that down to row 29, every cell shows a border. In Col C, I have a few rows of text. I format painted from A4 into C4 and down to C29 and only the cells with text have a border. Does this make sense?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks