Alternate Conditional Pattern as #'s Chg
Do the numbers change because the cell contains a formula or do they change
because of user input??
--
Gary''s Student
"Ken" wrote:
Excel2003 ...
I have a list of numbers which may repeat a random # of times.
The numbers are sorted in Ascending order.
Each time the number chgs I wish Conditional Format to "Alternate" the Cell
Pattern (ie: Blue, Grn, Blue, Grn etc)
What would Conditional Format formula be to achieve this?
Thanks ... Kha
|