That's why I included this:

But you can have a formula that will reevaluate when the workbook reculates:

<bg

But I agree with the emphasis!

Bob Phillips wrote:

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

--

Dave Peterson