software

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

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;JohnAOquot; gt; wrote in message
...
gt; I am creating a worksheet where different items are highlighted several
gt; different colors. Is there a way to create a formula that changes when I
gt; change the highlighted color of the row instead of having to remove a cell
or
gt; cells from one formula and add it to another? Thanks for any help!!
But you can have a formula that will reevaluate when the workbook reculates:
cpearson.com/excel/colors.htm
JohnAO wrote:
gt;
gt; I am creating a worksheet where different items are highlighted several
gt; different colors. Is there a way to create a formula that changes when I
gt; change the highlighted color of the row instead of having to remove a cell or
gt; cells from one formula and add it to another? Thanks for any help!!

--

Dave Peterson

That link was from Chip Pearson's site.

JohnAO wrote:
gt;
gt; I am creating a worksheet where different items are highlighted several
gt; different colors. Is there a way to create a formula that changes when I
gt; change the highlighted color of the row instead of having to remove a cell or
gt; cells from one formula and add it to another? Thanks for any help!!

--

Dave Peterson

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)

quot;Dave Petersonquot; gt; wrote in message
...
gt; That link was from Chip Pearson's site.
gt;
gt; JohnAO wrote:
gt; gt;
gt; gt; I am creating a worksheet where different items are highlighted several
gt; gt; different colors. Is there a way to create a formula that changes when
I
gt; gt; change the highlighted color of the row instead of having to remove a
cell or
gt; gt; cells from one formula and add it to another? Thanks for any help!!
gt;
gt; --
gt;
gt; Dave Peterson
That's why I included this:

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

lt;bggt;

But I agree with the emphasis!

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

--

Dave Peterson