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