Background cell color

%3CLINGO-SUB%20id%3D%22lingo-sub-1145721%22%20slang%3D%22en-US%22%3EBackground%20cell%20color%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1145721%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20using%20a%20Huawei%20MediaPad%20to%20work%20in%20Excel.%3C%2FP%3E%3CP%3EI%20often%20need%20to%20change%20cells%20colors%2C%20and%20every%20time%20I%20touch%20on%20the%20button%20to%20paint%20the%20cell%2C%20it%20displays%20all%20the%20available%20colors%20instead%20of%20just%20painting%20the%20cell%20with%20the%20default%20color%2C%20or%20the%20last%20color%20I%20used%2C%20which%20is%20always%20the%20same.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20anything%20I%20can%20do%20to%20make%20the%20pallet%20not%20open%20every%20time%20I%20need%20to%20paint%20a%20cell%3F%20Any%20configuration%3F%20Am%20I%20missing%20an%20update%20or%20something%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'd%20really%20appreciate%20your%20help!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20in%20advance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1145721%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1146396%22%20slang%3D%22en-US%22%3ERe%3A%20Background%20cell%20color%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1146396%22%20slang%3D%22en-US%22%3EIn%20Windows%20versions%2C%20I%E2%80%99m%20pretty%20sure%20you%20just%20click%20the%20paint%20pot%20(fill)%20icon%20to%20fill%20with%20last%20colour%20selected%20(not%20the%20drop%20down%20arrow%20but%20the%20actual%20pot%20part).%20Failing%20that%2C%20you%20could%20write%20a%20macro%20and%20assign%20a%20shortcut%20e.g.%20CTRL%20%2B%20f%3CBR%20%2F%3EThis%20would%20be%20the%20code%20and%20the%20fill%20colour%20is%20yellow%20(6)%3A%3CBR%20%2F%3E%3CBR%20%2F%3ESub%20YellowFill()%3CBR%20%2F%3ESelection.Interior.ColorIndex%20%3D%206%3CBR%20%2F%3EEnd%20Sub%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1147042%22%20slang%3D%22en-US%22%3ERe%3A%20Background%20cell%20color%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1147042%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F531239%22%20target%3D%22_blank%22%3E%40Charla74%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20answer!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThere%20is%20no%20drop%20down%20arrow%2C%20there%20is%20just%20the%20plain%20button%20with%20the%20pot...%20(See%20attached%20image)%3C%2FP%3E%3CP%3EI%20appreciate%20your%20advice%20of%20using%20a%20macro%2Cbut%20I%20don't%20think%20that%20would%20be%20a%20solution%20since%20I%20am%20using%20a%20tablet%2C%20and%20it%20will%20be%20the%20same%20amount%20of%20steps%20to%20reach%20Ctrl%2BF%20than%20touching%20the%20pot%20button%20and%20choosing%20the%20color%20I%20need%20every%20time%20I%20need%20it.%20%3CLI-EMOJI%20id%3D%22lia_disappointed-face%22%20title%3D%22%3Adisappointed_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1147045%22%20slang%3D%22en-US%22%3ERe%3A%20Background%20cell%20color%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1147045%22%20slang%3D%22en-US%22%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F541357%22%20target%3D%22_blank%22%3E%40Gustavo_Hopp%3C%2FA%3E%20Yes%2C%20I%20can%20see%20how%20that%20wouldn%E2%80%99t%20help%20without%20the%20keyboard.%3CBR%20%2F%3EThe%20only%20other%20thing%20I%20can%20suggest%2C%20which%20will%20be%20helpful%20if%20you%20do%20all%20the%20colour%20fill%20at%20one%20time%2C%20is%20the%20format%20painter%3B%20by%20double%20clicking%20on%20format%20painter%2C%20you%20can%20fix%20the%20function%20to%20repeat%20the%20formatting%20as%20many%20times%20as%20required.%3CBR%20%2F%3EHope%20this%20is%20of%20use.%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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 just painting the cell with the default color, or the last color I used, which is always the same.

 

Is there anything I can do to make the pallet not open every time I need to paint a cell? Any configuration? Am I missing an update or something?

 

I'd really appreciate your help!

 

Thank you in advance.

3 Replies
Highlighted
In Windows versions, I’m pretty sure you just click the paint pot (fill) icon to fill with last colour selected (not the drop down arrow but the actual pot part). Failing that, you could write a macro and assign a shortcut e.g. CTRL + f
This would be the code and the fill colour is yellow (6):

Sub YellowFill()
Selection.Interior.ColorIndex = 6
End Sub
Highlighted

@Charla74 

 

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.

 

 

Highlighted
@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.