Is there a forumula that uses colors instead of cell #'s?

J

JohnAO

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!!
 
B

Bob Phillips

No, as a colour change does not force a sheet recalculation.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
D

Dave Peterson

That link was from Chip Pearson's site.
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!!
Click to expand...
 
B

Bob Phillips

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)
 
D

Dave Peterson

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!
 
Top