| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Cell Color Function?
Hello -
I'm wondering if there is anyway to control cell color based on a condition? If a cell is not empty - color = red If the date is older than last week - color = blue If an IF statement is true, then color otherwise don't Thank you! |
|
#2
|
|||
|
|||
|
Cell Color Function?
You can use Conditional Formatting from the Format menu to do
this. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "DTTODGG" wrote in message ... Hello - I'm wondering if there is anyway to control cell color based on a condition? If a cell is not empty - color = red If the date is older than last week - color = blue If an IF statement is true, then color otherwise don't Thank you! |
|
#3
|
|||
|
|||
|
Cell Color Function?
Thank you.
How do I handle this: If a cell column K is blank, the set corresponding cell in column A to a color Again, thanks. I'm certain is Excel is very powerful, I just need to get up to speed as fast as possible. Is there a good place for examples? "Chip Pearson" wrote: You can use Conditional Formatting from the Format menu to do this. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "DTTODGG" wrote in message ... Hello - I'm wondering if there is anyway to control cell color based on a condition? If a cell is not empty - color = red If the date is older than last week - color = blue If an IF statement is true, then color otherwise don't Thank you! |
|
#4
|
|||
|
|||
|
Cell Color Function?
Select cell A1, then open the Conditional Formatting dialog.
Change "Cell Value Is" to "Formula Is", and enter =K1="" in the formula box, and choose the appropriate formatting from the Format button. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "DTTODGG" wrote in message ... Thank you. How do I handle this: If a cell column K is blank, the set corresponding cell in column A to a color Again, thanks. I'm certain is Excel is very powerful, I just need to get up to speed as fast as possible. Is there a good place for examples? "Chip Pearson" wrote: You can use Conditional Formatting from the Format menu to do this. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "DTTODGG" wrote in message ... Hello - I'm wondering if there is anyway to control cell color based on a condition? If a cell is not empty - color = red If the date is older than last week - color = blue If an IF statement is true, then color otherwise don't Thank you! |
|
#5
|
|||
|
|||
|
Cell Color Function?
Chip, thanks for the straight-forward example.
So simple - so beautiful. JLR "Chip Pearson" wrote: Select cell A1, then open the Conditional Formatting dialog. Change "Cell Value Is" to "Formula Is", and enter =K1="" in the formula box, and choose the appropriate formatting from the Format button. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "DTTODGG" wrote in message ... Thank you. How do I handle this: If a cell column K is blank, the set corresponding cell in column A to a color Again, thanks. I'm certain is Excel is very powerful, I just need to get up to speed as fast as possible. Is there a good place for examples? "Chip Pearson" wrote: You can use Conditional Formatting from the Format menu to do this. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "DTTODGG" wrote in message ... Hello - I'm wondering if there is anyway to control cell color based on a condition? If a cell is not empty - color = red If the date is older than last week - color = blue If an IF statement is true, then color otherwise don't Thank you! |
|
#6
|
|||
|
|||
|
Cell Color Function?
Select A1:A10
FormatConditional FormattingFormula is: =ISBLANK($K1).......note the $ sign which locks column K but not row 1. Pick a nice color from FormatPatterns and OK your way out. Gord Dibben Excel MVP On Mon, 7 Nov 2005 08:16:03 -0800, "DTTODGG" wrote: Thank you. How do I handle this: If a cell column K is blank, the set corresponding cell in column A to a color Again, thanks. I'm certain is Excel is very powerful, I just need to get up to speed as fast as possible. Is there a good place for examples? "Chip Pearson" wrote: You can use Conditional Formatting from the Format menu to do this. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "DTTODGG" wrote in message ... Hello - I'm wondering if there is anyway to control cell color based on a condition? If a cell is not empty - color = red If the date is older than last week - color = blue If an IF statement is true, then color otherwise don't Thank you! |
|
#7
|
|||
|
|||
|
Cell Color Function?
What you are describing is available with Conditional Formatting
Conditional Formatting http://www.mvps.org/dmcritchie/excel/condfmt.htm --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "DTTODGG" wrote in message ... Hello - I'm wondering if there is anyway to control cell color based on a condition? If a cell is not empty - color = red If the date is older than last week - color = blue If an IF statement is true, then color otherwise don't Thank you! |
|
#8
|
|||
|
|||
|
Cell Color Function?
David,
Thanks for the URL. Great examples, I'll have to read through them - lots to learn! JLR "David McRitchie" wrote: What you are describing is available with Conditional Formatting Conditional Formatting http://www.mvps.org/dmcritchie/excel/condfmt.htm --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "DTTODGG" wrote in message ... Hello - I'm wondering if there is anyway to control cell color based on a condition? If a cell is not empty - color = red If the date is older than last week - color = blue If an IF statement is true, then color otherwise don't Thank you! |
|
#9
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Cell Color Function?
OK, I'm back. Still learning about cell colors.
I have a report that I'm updating every week. It's cummulative, but the boss only wants to see what has changed. So, I have "highlighted" this weeks changes. But, next week, I would like to revert all the "highlighted" cells back to "no fill" color and "highlight" this weeks new changes. I can always pick the same color "highlight" if that makes it easy (find all the cells in yellow and change to no fill). Thank you so much for all of your help. "DTTODGG" wrote: David, Thanks for the URL. Great examples, I'll have to read through them - lots to learn! JLR "David McRitchie" wrote: What you are describing is available with Conditional Formatting Conditional Formatting http://www.mvps.org/dmcritchie/excel/condfmt.htm --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "DTTODGG" wrote in message ... Hello - I'm wondering if there is anyway to control cell color based on a condition? If a cell is not empty - color = red If the date is older than last week - color = blue If an IF statement is true, then color otherwise don't Thank you! |
|
#10
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Cell Color Function?
If you have a date to compare to on the row then you would compare
that date you would use $ sign in front of the column so you can make it apply to the entire row. =TODAY()$A1+7 or for within current week (or later) beginning on a Sunday =$A1(TODAY()-WEEKDAY(TODAY())) to restrict past and future dates to the current week beginning on a Sunday =AND($A1(TODAY()-WEEKDAY(TODAY())),$A1<=(TODAY()+7-WEEKDAY(TODAY()))) Or maybe you want to use a filter to show only those rows. http://www.contextures.com/tiptech.html -- --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "DTTODGG" wrote in message ... OK, I'm back. Still learning about cell colors. I have a report that I'm updating every week. It's cummulative, but the boss only wants to see what has changed. So, I have "highlighted" this weeks changes. But, next week, I would like to revert all the "highlighted" cells back to "no fill" color and "highlight" this weeks new changes. I can always pick the same color "highlight" if that makes it easy (find all the cells in yellow and change to no fill). Thank you so much for all of your help. "DTTODGG" wrote: David, Thanks for the URL. Great examples, I'll have to read through them - lots to learn! JLR "David McRitchie" wrote: What you are describing is available with Conditional Formatting Conditional Formatting http://www.mvps.org/dmcritchie/excel/condfmt.htm --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "DTTODGG" wrote in message ... Hello - I'm wondering if there is anyway to control cell color based on a condition? If a cell is not empty - color = red If the date is older than last week - color = blue If an IF statement is true, then color otherwise don't Thank you! |
|
#11
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Cell Color Function?
and what I just supplied you was already on the referenced page, but I've
just added a fragment-id so anyone can be directed directly to that point. http://www.mvps.org/dmcritchie/excel...tm#currentweek -- --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "David McRitchie" wrote in message ... If you have a date to compare to on the row then you would compare that date you would use $ sign in front of the column so you can make it apply to the entire row. =TODAY()$A1+7 or for within current week (or later) beginning on a Sunday =$A1(TODAY()-WEEKDAY(TODAY())) to restrict past and future dates to the current week beginning on a Sunday =AND($A1(TODAY()-WEEKDAY(TODAY())),$A1<=(TODAY()+7-WEEKDAY(TODAY()))) Or maybe you want to use a filter to show only those rows. http://www.contextures.com/tiptech.html -- --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "DTTODGG" wrote in message ... OK, I'm back. Still learning about cell colors. I have a report that I'm updating every week. It's cummulative, but the boss only wants to see what has changed. So, I have "highlighted" this weeks changes. But, next week, I would like to revert all the "highlighted" cells back to "no fill" color and "highlight" this weeks new changes. I can always pick the same color "highlight" if that makes it easy (find all the cells in yellow and change to no fill). Thank you so much for all of your help. "DTTODGG" wrote: David, Thanks for the URL. Great examples, I'll have to read through them - lots to learn! JLR "David McRitchie" wrote: What you are describing is available with Conditional Formatting Conditional Formatting http://www.mvps.org/dmcritchie/excel/condfmt.htm --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "DTTODGG" wrote in message ... Hello - I'm wondering if there is anyway to control cell color based on a condition? If a cell is not empty - color = red If the date is older than last week - color = blue If an IF statement is true, then color otherwise don't Thank you! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Input cell reference is not valid (One Variable Data Table) | Excel Worksheet Functions | |||
| Cell color based upon cell value | Excel Discussion (Misc queries) | |||
| cell color index comparison | New Users to Excel | |||
| Cell Change Color - Need Help | New Users to Excel | |||
| VLookup resulting in a blank cell... | Excel Worksheet Functions | |||
Hybrid Mode
