conditional formating

[Pa Maher]

In Excel 2007, for a large number of cells I want to create a conditional
formating rule based upon the value in the next cell.
For example, if the next cell has the value "c" then I want the original
cell to have a green fill and be boldened.
I can create the rule for the single cell but have not been able to copy it
to the other cells which should be looking at the value in the cell next to
them

 

[Gord Dibben]

Cell references in your description would help immensely but here is an
example.

Select column A and CF>New Rule>Use a Formula

=$B1="c"

Note the $ sign to fix the column but let the row number increment.


Gord Dibben MS Excel MVP

On Mon, 31 Aug 2009 13:44:01 -0700, Pa Maher <Pa