"Chris" <Chris@discussions.microsoft.com> wrote in message news:AD23880D-5EB9-4A6B-AA64-0951F5AD4D96@microsoft.com...
> I'd like to have my excel sheet columns with the dates to change to a
> specific color as the date pass's. I've racked my brain thinking of how.
> Anyone??
Then assign colors based on criteria you define, say, greater than Date+30,
then format color as green (or whatever you wish). Be aware you can only use
three conditional formats per cell.
HTH,
Kevin McClement
MOS Excel Specialist
"Chris" wrote:
> I'd like to have my excel sheet columns with the dates to change to a
> specific color as the date pass's. I've racked my brain thinking of how.
> Anyone??
"Chris" <Chris@discussions.microsoft.com> wrote in message news:AD23880D-5EB9-4A6B-AA64-0951F5AD4D96@microsoft.com...
> I'd like to have my excel sheet columns with the dates to change to a
> specific color as the date pass's. I've racked my brain thinking of how.
> Anyone??
Then assign colors based on criteria you define, say, greater than Date+30,
then format color as green (or whatever you wish). Be aware you can only use
three conditional formats per cell.
HTH,
Kevin McClement
MOS Excel Specialist
"Chris" wrote:
> I'd like to have my excel sheet columns with the dates to change to a
> specific color as the date pass's. I've racked my brain thinking of how.
> Anyone??
I'd like to have my excel sheet columns with the dates to change to a
specific color as the date pass's. I've racked my brain thinking of how.
Anyone??
"Chris" <Chris@discussions.microsoft.com> wrote in message news:AD23880D-5EB9-4A6B-AA64-0951F5AD4D96@microsoft.com...
> I'd like to have my excel sheet columns with the dates to change to a
> specific color as the date pass's. I've racked my brain thinking of how.
> Anyone??
Then assign colors based on criteria you define, say, greater than Date+30,
then format color as green (or whatever you wish). Be aware you can only use
three conditional formats per cell.
HTH,
Kevin McClement
MOS Excel Specialist
"Chris" wrote:
> I'd like to have my excel sheet columns with the dates to change to a
> specific color as the date pass's. I've racked my brain thinking of how.
> Anyone??
Bookmarks