Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting Error | Excel Worksheet Functions | |||
difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
conditional formatting question | Excel Discussion (Misc queries) | |||
Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |