For example if I have "Birthday" column in one of my worksheet and I want to
set up a reminder for upcoming birthday. How can I do that in Excel.

For a visual reminder how about using conditional formatting ??

"Excel Query" wrote:

> For example if I have "Birthday" column in one of my worksheet and I want to
> set up a reminder for upcoming birthday. How can I do that in Excel.

For a visual reminder how about using conditional formatting ??

"Excel Query" wrote:

> For example if I have "Birthday" column in one of my worksheet and I want to
> set up a reminder for upcoming birthday. How can I do that in Excel.

"Ron@Buy" wrote:

> For a visual reminder how about using conditional formatting ??
>
> "Excel Query" wrote:
>
> > For example if I have "Birthday" column in one of my worksheet and I want to
> > set up a reminder for upcoming birthday. How can I do that in Excel.


How can I use the conditional formatting? Can you explain me step by step
please?

"Ron@Buy" wrote:

> For a visual reminder how about using conditional formatting ??
>
> "Excel Query" wrote:
>
> > For example if I have "Birthday" column in one of my worksheet and I want to
> > set up a reminder for upcoming birthday. How can I do that in Excel.


How can I use the conditional formatting? Can you explain me step by step
please?

if you are using 2007 select cell with birthday select conditional format
from home ribbon, select format only cells that contain, in first selection
box select dates occurring, in the second select today, set format required
and OK
hope this helps
steve

"Excel Query" wrote:

> For example if I have "Birthday" column in one of my worksheet and I want to
> set up a reminder for upcoming birthday. How can I do that in Excel.

if you are using 2007 select cell with birthday select conditional format
from home ribbon, select format only cells that contain, in first selection
box select dates occurring, in the second select today, set format required
and OK
hope this helps
steve

"Excel Query" wrote:

> For example if I have "Birthday" column in one of my worksheet and I want to
> set up a reminder for upcoming birthday. How can I do that in Excel.

"steve h" wrote:

> if you are using 2007 select cell with birthday select conditional format
> from home ribbon, select format only cells that contain, in first selection
> box select dates occurring, in the second select today, set format required
> and OK
> hope this helps
> steve
>
> "Excel Query" wrote:
>
> > For example if I have "Birthday" column in one of my worksheet and I want to
> > set up a reminder for upcoming birthday. How can I do that in Excel.

Thank you. I was able to do that by conditional formatting. thanks again

"steve h" wrote:

> if you are using 2007 select cell with birthday select conditional format
> from home ribbon, select format only cells that contain, in first selection
> box select dates occurring, in the second select today, set format required
> and OK
> hope this helps
> steve
>
> "Excel Query" wrote:
>
> > For example if I have "Birthday" column in one of my worksheet and I want to
> > set up a reminder for upcoming birthday. How can I do that in Excel.

Thank you. I was able to do that by conditional formatting. thanks again