Conditional formatting

[C Tate]

How can I apply a conditional format to a range such that if a number in a
column is greater than the one in the preceding column, then it is fomatted
with a blue font? It is this business about formatting a number to the left
that has me lost!

[pinmaster]

Hi,
In conditional Formatting choose "Formula is:" and this:
=B1>A1

Hope this helps!
JG

[David McRitchie]

You last sentence seems to contradict your first sentence and would
probably just be ignored. If you did not get what you wanted from your
other answer then take a look at
http://www.mvps.org/dmcritchie/excel/condfmt.htm
The red lettering near the top is something to always keep in mind when
using Conditional Formatting. The formula supplied is correct but
you have to keep in mind the active cell and the cell selection when
assigning Conditional Formatting.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"C Tate" <[email protected]> wrote in message news:[email protected]...
> How can I apply a conditional format to a range such that if a number in a
> column is greater than the one in the preceding column, then it is fomatted
> with a blue font? It is this business about formatting a number to the left
> that has me lost!