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