7 Replies Latest reply: Sep 25, 2007 8:07 PM by 5|=vv
AJ3 Level 1 Level 1 (20 points)
I was wondering if two columns have the same value can I establish a condition that would underline one column?

Example:
Orig. Price Current Price
$200,000 $250,000
$350,000 _$350,000_


Thanks in advance.
AJ3

17in PowerBook, Mac OS X (10.4.3)
  • 1. Re: Format a cell with a conditional formula
    David Pearson Level 2 Level 2 (220 points)
    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?

    =IF(A1=B1,"✔")
    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
    David
  • 2. Re: Format a cell with a conditional formula
    5|=vv Level 3 Level 3 (685 points)
    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.
  • 3. Re: Format a cell with a conditional formula
    jaxjason Level 4 Level 4 (3,325 points)
    wow, I would never have thought of that one man. Your good.

    Jason
  • 4. Re: Format a cell with a conditional formula
    AJ3 Level 1 Level 1 (20 points)
    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.)
  • 5. Re: Format a cell with a conditional formula
    5|=vv Level 3 Level 3 (685 points)
    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?
  • 6. Re: Format a cell with a conditional formula
    AJ3 Level 1 Level 1 (20 points)
    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.
  • 7. Re: Format a cell with a conditional formula
    5|=vv Level 3 Level 3 (685 points)
    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).