Bolding a Cell under certain conditions
On Wed, 24 Sep 2008 16:32:06 -0700 (PDT), DennyP wrote:
I am looking for a program/function that takes in a selected column,
and bolds any cell in that column where the cell above or the cell
below has the same value.
The worksheet is already sorted on the selected column.
Thanks for any pointers or suggestions for Excel 2007.
Use conditional formatting (on the Home tab)
To apply this to C2:C10000
"Use a formula to determine which cells to format"
=OR(OFFSET(C2,-1,0)=C2,OFFSET(C2,1,0)=C2)
Then, in the CF Rules Manager, ensure the format applies to
=$C$2:$C$10000
--ron
|