Apple Event: May 7th at 7 am PT

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Conditional highlighting for a complete line

Hello

I searched the forum and elsewhere on the internet, no answer. However...

How can conditional highlighting be used for a complete line in Numbers?

null-OTHER, OS X El Capitan (10.11.6), Numbers

Posted on Mar 3, 2018 10:02 AM

Similar questions

conditional highlighting? is there any way to set a cell to turn (e.g.) green when the adjacent cell contains a certain text? i.e. A2='Work', therefore B2 cell Color Fills green. ?? OR A2='Creativity, therefore B2 cell Color Fills blue ??
485 14
Conditional highlight in numbers How do I set up a conditional highlight in numbers for a duplicate number or name. could do this in Excel having trouble with numbers iMac
289 6
iCloud Numbers Conditional Highlighting - Where Is It? Hello, I was trying to add conditional highlighting to a sheet in the web iCloud version of numbers and I cannot seem to find it. I would love to move away from Office and use iCloud more, but I use this feature on a bunch of sheets. Is there anything I can do? Thank you!
1209 3

21 replies

SGIII

Level 8

35,306 points

Mar 6, 2018 9:47 AM in response to Marc-Andr St-Pierre

Marc-Andr St-Pierre wrote:

sethighlightColor1to {65535, 65535, 2713} --"yellow"

set highlightColor2 to {0, 0, 65416} -- "blue"

Where can we find the numbers for these color codes?

One way to get the color code is to first color the fill of a cell to your liking.

Then to get the code for the color in the cell, select the cell, and run the script below. The result will be in the 'Result' pane of Script Editor. You can copy-paste it from there to another script, or whatever.

--get background color of a Numbers cell (if none returns 'missing value')

tell application "Numbers" to tell front document

set t to active sheet'stable 1 whose selection range'sclass is range

set bkgrRgb to t'sselection range'scell 1's background color

--> e.g. {64720, 17976, 19514}

end tell