I have recently starting using Numbers, being an Excel user for years.
I often fill cells with a yellow background to highlight them.
In Excel you can do this from a simple colour menu in the toolbar at the top.
I have found no quick and easy way to do this in Numbers.
Any advice would be appreciated.
thank you
iMac, OS X Mavericks (10.9.5)
The following in practice, will allow you to select your cells for color fill, click the colorwheel on the toolbar, and then directly drag/drop the saved color onto your cell selection. Not a slick, one-button click as presented by HD.
Drag/drop colorwheel icon to the Toolbar
As far as I can tell there's no direct equivalent of the little paintbucket button in Excel that remembers the last colour you filled with.
One quick and relatively easy way to achieve it would be with an AppleScript:
tell application "Numbers" to tell front document to tell active sheet
try
set active_table to (first table whose class of selection range is range)
on error
display alert "No selection" buttons {"OK"} default button 1
return
end try
tell active_table
set background color of selection range to {62466, 65535, 28003}
end tell
end tell
This could be run from Numbers' script menu (screen grab below) or saved as an Automator Service and run from a popup or keyboard shortcut (eg ctrl-y).
Post back if you'd like to follow up either of those ideas.
Thank you, I really appreciate your help.
Everything worked perfectly
Thank you for your help.
I have now been advised of an approach which works for me, but really appreciate your assistance
How do I create a shortcut to fill cells with the same background colour
