Conditional Formatting
 

I have a sheet that needs to compare AGE to LIFE EXPECTANCY. It also needs
to highlight the entire row when the age is greater than the life expectancy.


Thanks

Conditional Formatting
 

Hi,

This assumes age in col D expectancy in Col E. Select the rows to format and
then

Format|Conditional format
Formula is
=$D2$E2

Pick a colour
Change 2 to the top row of the range.

Mike


"sojuman" wrote:

I have a sheet that needs to compare AGE to LIFE EXPECTANCY. It also needs
to highlight the entire row when the age is greater than the life expectancy.


Thanks

Conditional Formatting
 

With the age in Column J and Life Expectancy in Column K, highlight all your
data & use the Conditional Formatting formula:

=$J2$K2

and set your format pattern colour.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"sojuman" wrote in message
...
I have a sheet that needs to compare AGE to LIFE EXPECTANCY. It also needs
to highlight the entire row when the age is greater than the life
expectancy.


Thanks

Conditional Formatting
 

Thanks Mike, works great.

"Mike H" wrote:

Hi,

This assumes age in col D expectancy in Col E. Select the rows to format and
then

Format|Conditional format
Formula is
=$D2$E2

Pick a colour
Change 2 to the top row of the range.

Mike


"sojuman" wrote:

I have a sheet that needs to compare AGE to LIFE EXPECTANCY. It also needs
to highlight the entire row when the age is greater than the life expectancy.


Thanks

Conditional Formatting
 

Thank you. How about if I wanted to show which ones were within 1-3 years of
reaching their life?

"Sandy Mann" wrote:

With the age in Column J and Life Expectancy in Column K, highlight all your
data & use the Conditional Formatting formula:

=$J2$K2

and set your format pattern colour.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"sojuman" wrote in message
...
I have a sheet that needs to compare AGE to LIFE EXPECTANCY. It also needs
to highlight the entire row when the age is greater than the life
expectancy.


Thanks

Conditional Formatting
 

Hi,

This one start at e2-3years

=$D2$E2-3

Mike

"sojuman" wrote:

Thank you. How about if I wanted to show which ones were within 1-3 years of
reaching their life?

"Sandy Mann" wrote:

With the age in Column J and Life Expectancy in Column K, highlight all your
data & use the Conditional Formatting formula:

=$J2$K2

and set your format pattern colour.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"sojuman" wrote in message
...
I have a sheet that needs to compare AGE to LIFE EXPECTANCY. It also needs
to highlight the entire row when the age is greater than the life
expectancy.


Thanks

Conditional Formatting
 

Assuming that you mean highlight for the three years leading up to the Life
Expectancy but not to highlight after then try:

=AND($J2=$K2-3,$J2<=$K2)

If you mean to highlight from three years before and aslo aftewards try:

=$J2=$K2-3

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"sojuman" wrote in message
...
Thank you. How about if I wanted to show which ones were within 1-3 years
of
reaching their life?

"Sandy Mann" wrote:

With the age in Column J and Life Expectancy in Column K, highlight all
your
data & use the Conditional Formatting formula:

=$J2$K2

and set your format pattern colour.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"sojuman" wrote in message
...
I have a sheet that needs to compare AGE to LIFE EXPECTANCY. It also
needs
to highlight the entire row when the age is greater than the life
expectancy.


Thanks

Conditional Formatting
 

That was an easy one. Thanks.

Tony

"Mike H" wrote:

Hi,

This one start at e2-3years

=$D2$E2-3

Mike

"sojuman" wrote:

Thank you. How about if I wanted to show which ones were within 1-3 years of
reaching their life?

"Sandy Mann" wrote:

With the age in Column J and Life Expectancy in Column K, highlight all your
data & use the Conditional Formatting formula:

=$J2$K2

and set your format pattern colour.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"sojuman" wrote in message
...
I have a sheet that needs to compare AGE to LIFE EXPECTANCY. It also needs
to highlight the entire row when the age is greater than the life
expectancy.


Thanks

Conditional Formatting
 

Thanks. Between you and Mike, this workbook is coming together nicely.

Tony

"Sandy Mann" wrote:

Assuming that you mean highlight for the three years leading up to the Life
Expectancy but not to highlight after then try:

=AND($J2=$K2-3,$J2<=$K2)

If you mean to highlight from three years before and aslo aftewards try:

=$J2=$K2-3

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"sojuman" wrote in message
...
Thank you. How about if I wanted to show which ones were within 1-3 years
of
reaching their life?

"Sandy Mann" wrote:

With the age in Column J and Life Expectancy in Column K, highlight all
your
data & use the Conditional Formatting formula:

=$J2$K2

and set your format pattern colour.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"sojuman" wrote in message
...
I have a sheet that needs to compare AGE to LIFE EXPECTANCY. It also
needs
to highlight the entire row when the age is greater than the life
expectancy.


Thanks