Apple Event: May 7th at 7 am PT
So I know through conditional formatting I am able to change the background color of the individual cell that the Pop Up Menu is located in, but is there a way to adjust the entire row color. My spreadsheet gets a little long, even with locked headers and footers, it would be easier to have the row color change based on the status I set in the pop up menu.
Any ideas? Is this possible?
iMac, Mac OS X (10.7.3), Quad Core i7 3.4 GHz
As far as I know, the only way to color an entire row is via AppleScript.
For example, a table with the Popup in the first column could be handled this way:
SG
--highlight a row based on value found in column testColumn on that row
property testCol : 1 -- 1 is column A, 2 is column B, etc
property testValue : "PopVal2"
property highlightColor : "red"
tell application "Numbers"
tell document 1 to tell active sheet
set t to first table whose class of selection range is range
repeat with i from 2 to count t's rows -- from 2 to skip Header Row
tell t's row i
set v to its cell testCol's formatted value
if v is testValue then set its background color to highlightColor
end tell
end repeat
end tell
end tell
Hi M.,
AppleScript may be the way to go for this. There are some conditional highlighting solutions but they can be kludgy.
The least kludgy for your situation may be to add a column down your row that holds the value you want as a trigger. The rule would match the values between the popup and the new cell. So it would highlight when the popup did.
Another approach would be to create a second table that has the popup trigger value in each cell with the same rule. This would be dragged behind your actual table and the highllights would show thru.
quinn
Can I make Pop Up Menu Cell adjust entire ROW color?
