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!