|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
January 6th, 2006, 04:42 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
Is there a forumula that uses colors instead of cell #'s?
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!! 
|
|
#2
January 6th, 2006, 04:54 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Is there a forumula that uses colors instead of cell #'s?
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!!
|
|
#3
January 6th, 2006, 08:36 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Is there a forumula that uses colors instead of cell #'s?
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
|
|
#4
January 6th, 2006, 08:37 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Is there a forumula that uses colors instead of cell #'s?
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
|
|
#5
January 7th, 2006, 08:55 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
|
|
#6
January 7th, 2006, 03:35 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Is there a forumula that uses colors instead of cell #'s?
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
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Instead of a negative number, I'd like to show zero... | Dr. Darrell | Worksheet Functions | 6 | December 7th, 2005 08:21 PM |
| How to add fill colors (cell shading) in EXCEL? | Donna Sherman | General Discussion | 2 | April 21st, 2005 07:24 PM |
| Changing Cell References | Katrina | Worksheet Functions | 1 | September 22nd, 2004 05:37 PM |
| IF E3 & E10 = TRUE set this cell to "Yes", else set to "No" | Timothy L | Worksheet Functions | 5 | August 27th, 2004 02:28 AM |
| Convert a Cell Reference to Text | Chuck Buker | Worksheet Functions | 6 | September 22nd, 2003 05:04 PM |
Linear Mode
