Modifying “Changing background colors of cells in mac numbers” that is here: Changing background colors of cells in ma… - Apple Community
Can this AppleScript be adopted to work with the current cell selected rather than the selection be based on a range?
I thought I had misunderstood your question. Maybe the piece of code below will help to get you started. It replaces the first part of the code provided by SGIII (and it is basically from another script of his). It is a handy little snippet of code to have around when you want to write a script that does something to a selected range of cells.
tell application "Numbers"
tell front document's active sheet
tell (first table whose selection range's class is range)
set selRange to selection range
repeat with c in selRange's cells
set c's background color to my hexColortoRGB("#143C23")
end repeat
end tell
end tell
end tell
I thought I had misunderstood your question. Maybe the piece of code below will help to get you started. It replaces the first part of the code provided by SGIII (and it is basically from another script of his). It is a handy little snippet of code to have around when you want to write a script that does something to a selected range of cells.
tell application "Numbers"
tell front document's active sheet
tell (first table whose selection range's class is range)
set selRange to selection range
repeat with c in selRange's cells
set c's background color to my hexColortoRGB("#143C23")
end repeat
end tell
end tell
end tell
Thanks Barry. I use Keyboard Maestro with palettes. If I could select a cell and apply a background color by clicking on an option in a palette, that would be efficient enough by saving multiple actions.
Badunit, your reply re: range of one was most helpful. I don't know why you deleted it. I might be able to adjust the script to work knowing that. Then again, I might not with my rudimentary AS understanding.
Perfect, works just as I need. Thank you!
And let me add that I'm crystal clear no one is obligated in any way to answer questions in this forum and that giving your time and attention is pure generousity and a gift. That's closer to what I mean by the simple much used 'Thank you' 🫡
Possibly, but when applying it to single cells, I suspect copy and paste would be more efficient.
Regards,
Barry
deleted..
Set Numbers cell background color using AS with targeted cell based on selected cell