Skip navigation
This discussion is archived

Format a cell with a conditional formula

5179 Views 7 Replies Latest reply: Sep 25, 2007 8:07 PM by 5|=vv RSS
AJ3 Calculating status...
Currently Being Moderated
Sep 24, 2007 1:28 PM
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)
  • David Pearson Calculating status...
    Currently Being Moderated
    Sep 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?

    =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
    MBP 17", Mac OS X (10.4.10), If Apple Sell it, we probably have it!
  • 5|=vv Level 3 Level 3 (685 points)
    Currently Being Moderated
    Sep 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)
  • jaxjason Level 4 Level 4 (3,320 points)
    Currently Being Moderated
    Sep 24, 2007 5:36 PM (in response to 5|=vv)
    wow, I would never have thought of that one man. Your good.

    Jason
    Power Mac Dual 2.0 G5, Mac OS X (10.4.10)
  • 5|=vv Level 3 Level 3 (685 points)
    Currently Being Moderated
    Sep 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)
  • 5|=vv Level 3 Level 3 (685 points)
    Currently Being Moderated
    Sep 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)

Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.