Can you apply conditional formatting on a cell no matter is in it. See attached. The 3 areas named Line Trucks, Personnel Vehicles and Trailers are auto sorted according to the value, shown in "C". I would like the font to change to red in the top row only no matter what vehicle is in that cell. I can do it for the "C" column because it is the highest number in the column, but the vehicle column is giving some trouble because it is not the highest. I only attached a copy of the one sheet but if the whole workbook is needed then I can post it.
Bookmarks