Cell Color Function?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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
 
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?
 
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
 
David,

Thanks for the URL. Great examples, I'll have to read through them - lots to
learn!
JLR
 
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
 
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.
 
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
 
Back
Top