Is there a forumula that uses colors instead of cell #'s?
But that requires a manual action to recalculate, it won't happen if the
cell colour is just changed.
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"Dave Peterson" wrote in message
...
That link was from Chip Pearson's site.
JohnAO wrote:
I am creating a worksheet where different items are highlighted several
different colors. Is there a way to create a formula that changes when
I
change the highlighted color of the row instead of having to remove a
cell or
cells from one formula and add it to another? Thanks for any help!!
--
Dave Peterson
|