Cell Color Function?

[DTTODGG]

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!

 

[Chip Pearson]

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

 

[David McRitchie]

What you are describing is available with Conditional Formatting
Conditional Formatting
http://www.mvps.org/dmcritchie/excel/condfmt.htm

 

[DTTODGG]

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]

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]

David,

Thanks for the URL. Great examples, I'll have to read through them - lots to
learn!
JLR

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

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!

 

[DTTODGG]

Chip, thanks for the straight-forward example.
So simple - so beautiful.
JLR

 

[Gord Dibben]

Select A1:A10

Format>Conditional Formatting>Formula is:

=ISBLANK($K1).......note the $ sign which locks column K but not row 1.

Pick a nice color from Format>Patterns and OK your way out.


Gord Dibben Excel MVP

 

[DTTODGG]

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.

David,

Thanks for the URL. Great examples, I'll have to read through them - lots to
learn!
JLR

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

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!

 

[David McRitchie]

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

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.

David,

Thanks for the URL. Great examples, I'll have to read through them - lots to
learn!
JLR

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

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!

 

[David McRitchie]

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/condfmt.htm#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

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

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.

David,

Thanks for the URL. Great examples, I'll have to read through them - lots to
learn!
JLR

:

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

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!