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!