Drag down Conditional Formatting.

Question

Level 1

10 points

Drag down Conditional Formatting.

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

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)

Posted on Jan 2, 2013 5:30 PM

Reply

Answer 1

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.

Jerry

Reply