Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I am using apple numbers to do some modeling.

(For those of you who are not familiar it is the apple version of excel that makes awesome looking charts, but has a bit less functionality).

I am using Numbers 08 version 1.

I have three cells right now with this:

-------------------------------------
| A1 | A2 | =IF(A1>A2, "PROBLEM!","")
-------------------------------------

However I would prefer to somehow highlight A1 in red when it is higher than A2. Is there anyway that I can do that?

share|improve this question

2 Answers 2

up vote 0 down vote accepted

Here's a workaround using a novel idea to overlay tables:

http://www.numberstemplates.com/2007/10/05/conditional-formatting-hack/

share|improve this answer

as far as i know, there is no way to use cell references in the conditional formatting dialog box in numbers 08.

i use numbers 09 and there you are able to do exactly what you want.

still, it can't hold a candle to excel.

share|improve this answer
    
Just out of curiosity why? –  sixtyfootersdude Jun 22 '10 at 21:28

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.