This discussion is archived
5179 Views 7 Replies Latest reply: Sep 25, 2007 8:07 PM by 5|=vv
Currently Being ModeratedSep 24, 2007 2:54 PM (in response to AJ3)AJ3,
hum it would appear not using the conditional formula on the inspector which cannot accept another cell or formula as its control, simply a fixed value ;-(
Even then you only seem able to change the background and the font colour (read color in the USA)
Would a tick in the column to the right work for you?
Where A1 is cell of the first number and B1 is the one you are comparing it to.
Sorry that's all I could find
DavidMBP 17", Mac OS X (10.4.10), If Apple Sell it, we probably have it!
Currently Being ModeratedSep 24, 2007 5:15 PM (in response to AJ3)Here's a workaround for Number's regrettable lack of "third-party" conditional cell formatting. The result is thus:
Here is another screenshot that indicates how it was done:
In general, the idea is to use a second table containing a formula that can be used to compute the conditional format, an orange colored (read "coloured" in Britian, etc. ) cell background. In this case the formula is an IF() comparing the equality of the two columns in the first table (see the formula bar in the second screenshot). Note that both the text and the background conditional format rules have been set to orange. This causes the "TRUE"s that would otherwise spoil the effect to disappear.
Then, using the "Table Inspector" panel, set the cell background of the first table to "None". The effect is completed by sending the second table to the back (select the table as a canvas item indicated with square selection handles and use menu item "Arrange"/"Send to Back") and align the tables with mouse or arrow keys.Mac OS X (10.4)
Currently Being ModeratedSep 25, 2007 11:28 AM (in response to 5|=vv)Once again ... You've changed the way I look at things.
You are to NUMBERS as Bobby Fischer was to Chess!
Your suggestion is a display of your functional capacity of knowledge as well as your creative ways to think outside the box.
Unfortunately this will not work for my desired end result. (Cut and Paste the table data into InDesign for a multiple column layout.)17in PowerBook, Mac OS X (10.4.3)
Currently Being ModeratedSep 25, 2007 12:32 PM (in response to AJ3)So what format are you expecting on the clipboard to paste into InDesign? Was it something graphical, or, getting back to the start of this thread, was it rich text and thus the reason for wanting underlining?Mac OS X (10.4)
Currently Being ModeratedSep 25, 2007 7:31 PM (in response to 5|=vv)I want an underline if that List Price, A, matches the Original List price, B, so when I paste it into InDesign, there will be an underline. I believe that would be rich text. So far it works great.
Also if another column C matches D, Bold would work too... or If E matches F then an Asterik.
Any of those would work.17in PowerBook, Mac OS X (10.4.3)
Currently Being ModeratedSep 25, 2007 8:07 PM (in response to AJ3)So I'm not aware of a way to drive text format (underline, bold, etc.) via a computation (List Price A = List Price B). Actually adding a character (an asterisk or a bullet, etc) could be done computationally.
My trick above, as you well know, is purely graphical. You need to actually manipulate the values (possible) or their text formats (not possible, I think).Mac OS X (10.4)