Conditional formatting
 

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!

Conditional formatting
 

Hi,
In conditional Formatting choose "Formula is:" and this:
=B1A1

Hope this helps!
JG


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=493765

Conditional formatting
 

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" wrote in message ...
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!