I have read and read the 'How to', but I'm completely baffled as to how I can create cells in column J (file attached) to reflect the red text colour cells in column B which will then allow me to do a sort on that conditional formatted B column.
If I understand correctly I need to get the column J cells to say yes or no and the sort will work.
Could someone please give me the answer?
Last edited by meridklt; 10-18-2007 at 02:38 PM.
Click on B1 then Format / conditional formating
This will show you the formula associated with the red text. Copy that formula "=NOT(ISERROR(VLOOKUP(B1,F:F,1,FALSE)))" into cell J1 and then past down
on a sepearte column, enter your conditional formating formula, then hide the column.
Sort by that hidden column
Please Login or Register to view this content.
NOT(ISERROR is a rather more elaborate construction than you need for the conditional formatting. You can use
=COUNTIF(F:F,B1)
then the formula in column J can, similarly, be
=COUNTIF(F:F,B1)>0
Thanks for the help chaps, but I still am unable to sort with any of your suggestions. I still end up with the J column content as column B is and not displaying with a 'YES' 'NO' text to sort on.
I have attached a new file incorporating your suggestions in their own worksheet. So could you be so kind as to explain where I'm going wrong with your answer and perhaps attach the corrected file to your reply.
Last edited by meridklt; 10-18-2007 at 04:42 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks