Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi all
I am trying to apply conditional formatting a column of figures as follows: If the contents of cell B1 are greater than the contents of cell A1 then display content in Red. If the contents of cell B1 are less than the contents of cell A1 then display content in Blue. That bit is easy :-) but I am having a problem applying the formatting to a range of cells, i.e. B2:B20. Do I have to apply it to all cells individually? Not sure how to progress so I would really appreciate a little help. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional formatting in Excel 2007 | New Users to Excel | |||
Conditional Formatting in Excel 2007 | Excel Discussion (Misc queries) | |||
Conditional Formatting In Excel 2007 | Excel Discussion (Misc queries) | |||
Using conditional formatting in Excel 2007 | New Users to Excel | |||
Conditional formatting in Excel 2007 | Excel Discussion (Misc queries) |