Here is a small example in the file and instructions: Then mark the column -> Conditional formatting -> Rules for highlighting cells -> Equal ... -> enter the text color here and select the formatting next to it. Light red, yellow and green already exist, all other formatting has to be done by hand. I memorized the 3 color values of the background when filling in -> other colors ... and entered these values for the font color -> other colors ... Now every cell should have a dropdown with the names of the colors. To do this, mark the colored cells, transfer format -> click on the column header of the desired column. Hope I was able to help you and would be happy to know if I could help you. I would be happy to know if I could help. Nikolino I know I don't know anything (Socrates) * Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here. Related posts:
|