5322 Views 7 Replies Latest reply: Sep 25, 2007 8:07 PM by 5|=vv
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
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.
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.)
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.
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).