Please Log in or Create an account to join the conversation. Each column C through L has its own sheet that corresponds to it.Īnother example: I want Column D with FL-01 in Cell D8 to show Green from the Drop Down Cell in C-8 on Sheet2 and change when I change the Drop Down option. I would like to retain that information in its cell but be updated with the corresponding color when I select it from the drop down list.įor confidentiality reasons, I am unable to upload the file but I can say that I have 9 columns from C to L and 29 rows. So, its really important to completely uninstall Kutools for Excel and remove. I have the item that is issued with an ID number such as FL-01 to indicate which item they were issued. An incomplete uninstallation of Kutools for Excel may also cause many problems.
On these other sheets, I have a conditional formatting drop down list with 5 colors essentially White, Red, Yellow, Green and Cyan for Not Issued, Missing, Out of Service, Issued and Returned respectively. ExtendOffice Note: The other languages of the website are Google-translated. Kutools integrates with Microsoft Office 2007 and on, as well as Office 365.
I am creating an assignment log for my work and I have Sheet1 acting as a display of who has what equipment assigned to them. Kutools for Excel is a downloadable suite designed to simplify, automate and expand the features and functions of Microsoft Excel. Kutools for Excel is a powerful add-in that frees you from performing time-consuming operations in Excel, such as combining sheets quickly, merging cells without losing data, pasting to only visible cells, counting cells by color and so on.