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?
Bookmarks