Please help - I have a table with customers, their requests, the delivery deadlines, and a last column is where I have dropdown list with the status of the order - cancelled, delivered ect. So, is there a way to format so that once im over the delivery date, whole row changes colour, but when I set the status to "delivered" it changes to a different colour?
Thank you very much! I’ve looked all over for what I needed, and this is it! Great tutorial!
Thank you very much for explaining it with detailed information and so neatly and clearly. Thanks a lot
Superb performance
what would be the formula if I wanted the different cell to be highlighted if it's between 2 values example between 20.00 to 30.00?
Please help - I have a table with customers, their requests, the delivery deadlines, and a last column is where I have dropdown list with the status of the order - cancelled, delivered ect. So, is there a way to format so that once im over the delivery date, whole row changes colour, but when I set the status to "delivered" it changes to a different colour?
Thanks for How to product the same sheet but multiple user control in same sheet
exm, A column only edit Mr. A B column only edit Mr. B how to do this
HI HOW DO I SUBTRACT 1 unit from 4-5 different CELLS IF SHEET 2 maybe cell B4 is 1?