Conditional Formatting -- Apply to Row if Cell Value does not
Aha! Thank you!
"Jim Thomlinson" wrote:
You do wnat tot use condtional formatting but you need to chage from cell
value to formula. Highlight Rows A:AS and then in conditional formatting do
something like
=$A3<$A2
This formula will condionally format when the Cell in A is not equal to the
cell above.
--
HTH...
Jim Thomlinson
"SteveC" wrote:
In Column A, How to I insert lines for whenever the values change for the
entire row A:AS.
Pears
Pears
Pears
Apples
Apples
Oranges
Oranges
I tried conditional formatting, but I only figured out how to use it for a
specific cell, not a row, and only for specific cells -- not relative to
changes to the cell above...
thanks very much...
|