Conditional formatting syntax - single cell reference value?

[Bebbspoke]

Please can someone give link to the syntax of Conditional formatting and formulae in Excel 2007?

Either a website or manual source would be appreciated.

I wish to process large quantities of columnar numeric data with arguments (e.g.): -

=IF((An + reference cell value)<Bn,1,0)

Thank you.

[Special-K]

Bit more info what youre trying to achieve would be better

[jeffreybrown]

In conditional formatting you really do not need the IF statement.

In other words

=IF((An + reference cell value)<Bn,1,0)

=1+B1<10 >> Pick format

1 equals An
10 equals Bn
B1 the referenced cell

[lwflip]

I found the conditional formatting examples in this reference to be helpful. Look at example 5 on that site. It looks like the conditional formatting formula part of Excel already does the IF() statement. So you should only have to do the condition part.

i.e. An begins on A1, Bn begins on B1 and the referenced cell value is at C1, highlight range A and try:
=A1+$C$1<B1

http://www.techrepublic.com/blog/10t...g-feature/3166

[Bebbspoke]

Bit more info what youre trying to achieve would be better

(Special-K); PLEASE - I am NOT interested in ploughing through "examples" which might be doing something near...

Compare columns of numeric data where a "constant" as derived from a value within an unrelated single cell is added to each cell in one of the data columns.

my requirements - surely somewhere Excel 2007 syntax is fully documented?
To fully explain my requirements would be a ridiculous undertaking. Sufficient detail has been given.

(jeffrey) I doubt this will work - I am certainly not entering the equation into +15k rows individually...

Thank you (lwflip) for giving a clue as to the syntax of the $ operator

[martindwilson]

cf works on true/false nearly any formula that results in true/false can be used

[jeffreybrown]

To fully explain my requirements would be a ridiculous undertaking. Sufficient detail has been given.

You may not think this comes off as rude, but it does. We certainly are not trying to provide you with any wild goose chase, but what you did provide as an explanation was not sufficient in my opinion and since two of us where not quite sure...

Well, that is entirely up to you to decide but best wishes for the rest of your project.

Thank you (lwflip) for giving a clue as to the syntax of the $ operator

Hmmm...didn't realize this was part of your question.
Switch between relative, absolute, and mixed references