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)

"JohnAO" wrote in message
...
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!!

But you can have a formula that will reevaluate when the workbook reculates:
http://cpearson.com/excel/colors.htm



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

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

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

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