Skip navigation

Drag down Conditional Formatting.

273 Views 1 Reply Latest reply: Jan 2, 2013 7:07 PM by Jerrold Green1 RSS
4r1 Level 1 Level 1 (10 points)
Currently Being Moderated
Jan 2, 2013 5:30 PM

Hello,

 

This is a question that I have seen already here that was archived (at least 2 years ago) before it was properly answered, and I would like to see if we can solve it.

 

When conditional formatting a cell I use this expression: is equal to (J8)

I want to format the next cell down as: is equal to (J9)

and the next

and the next

etc

 

The answer they came up with was "do it by hand" but I have 3645 entries to fill in, and that would drive me completely mad :-)

 

Any answers for this?

 

Thanks

Ari

MacBook Pro, Mac OS X (10.7.2)
  • Jerrold Green1 Level 7 Level 7 (28,185 points)
    Currently Being Moderated
    Jan 2, 2013 7:07 PM (in response to 4r1)

    Ari,

     

    Nothing has changed in that regard. The best workaround in my opinion is to add an auxiliary column to be the indicator of the condition you wish to highlight. In the auxiliary column you can calculate a result that you can then apply normal, non external cell referenced, conditions to.

     

    Here's an example where the condition of a column to column comparison is flagged by a red cell, just not one of the data cells.

    Screen Shot 2013-01-02 at 10.05.16 pm.png

     

    Jerry

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.