Conditional Formatting

M

Mikey

Referencing a column which holds birth dates, I would like
to highlight subsequent birthdays using conditional
formatting.

Mikey
 
D

Domenic

Referencing a column which holds birth dates, I would like
to highlight subsequent birthdays using conditional
formatting.

Mikey
Click to expand...

Hi Mikey,

Assuming that your date of births are listed in Column A:

1) Select the range of cells you would like conditionally formatted
2) Format > Conditional Format
3) Change "Cell Value Is" to "Formula Is"
4) Enter this formula --> =DATE(YEAR(TODAY()),MONTH(A1),DAY(A1))>TODAY()
5) Click on "Format" and select the formatting you want
6) Click Ok

If you want the entire row formatted, then repeat the above but substitute
the formula with this one:

=DATE(YEAR(TODAY()),MONTH($A1),DAY($A1))>TODAY()

Hope this helps!
 
G

Guest

-----Original Message-----


Hi Mikey,

Assuming that your date of births are listed in Column A:

1) Select the range of cells you would like conditionally formatted
2) Format > Conditional Format
3) Change "Cell Value Is" to "Formula Is"
4) Enter this formula --> =DATE(YEAR(TODAY()),MONTH (A1),DAY(A1))>TODAY()
5) Click on "Format" and select the formatting you want
6) Click Ok

If you want the entire row formatted, then repeat the above but substitute
the formula with this one:

=DATE(YEAR(TODAY()),MONTH($A1),DAY($A1))>TODAY()

Hope this helps!
Click to expand...

Hi Domenic, didn't work, below is line from ss>

A B C D
dob ret date age format on b'day
 
G

Guest

-----Original Message-----
conditionally

Hi Domenic, didn't work, below is line from ss>

A B C D
dob ret date age format on b'day
.Hi Dominic, sorry worked fine thanks - copied but forgot
Click to expand...
to chx cell ref, doh!

Thanks again
 
D

Domenic

Hi Domenic, didn't work, below is line from ss>

A B C D
dob ret date age format on b'day
8-May-1985 8-May-2050 19
Click to expand...

I'm a little confused. Your original post said format subsequent birthdays
(I took that to be upcoming birthdays), and now you're saying format on
birthday. Anyways...

Format on Birthday:

=DATE(YEAR(TODAY()),MONTH($A2),DAY($A2))=TODAY()


Format on Birthday and later:

=DATE(YEAR(TODAY()),MONTH($A2),DAY($A2))>=TODAY()

Cheers!
 
D

Domenic

Hi Dominic, sorry worked fine thanks - copied but forgot
to chx cell ref, doh!

Thanks again
Click to expand...

Didn't see your last post before I posted my message. Glad I could help!

Cheers!
 
Top