Forum Discussion
Gustavo_Hopp
Feb 01, 2020Copper Contributor
Background cell color
Hello, I am using a Huawei MediaPad to work in Excel. I often need to change cells colors, and every time I touch on the button to paint the cell, it displays all the available colors instead of...
Gustavo_Hopp
Feb 02, 2020Copper Contributor
Thank you for your answer!
There is no drop down arrow, there is just the plain button with the pot... (See attached image)
I appreciate your advice of using a macro,but I don't think that would be a solution since I am using a tablet, and it will be the same amount of steps to reach Ctrl+F than touching the pot button and choosing the color I need every time I need it. 😞
Charla74
Feb 02, 2020Iron Contributor
Gustavo_Hopp Yes, I can see how that wouldn’t help without the keyboard.
The only other thing I can suggest, which will be helpful if you do all the colour fill at one time, is the format painter; by double clicking on format painter, you can fix the function to repeat the formatting as many times as required.
Hope this is of use.
The only other thing I can suggest, which will be helpful if you do all the colour fill at one time, is the format painter; by double clicking on format painter, you can fix the function to repeat the formatting as many times as required.
Hope this is of use.